Change data with an import

[FireGeek21]

Looking to find out if it is possible to change existing data in an Access table with data from an import file (Excel) based on a key field.

Ideas on how to do this???

Thanks!!

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)

 

[Andrzejek]

Yes.
Read a row of data from Excel file
Run the statement:
[tt]
UPDATE MyAccessTable
Set SomeFieldInTable = SomeFieldFromExcel,
SomeOtherFieldInTable = SomeOtherFieldFromExcel
WHERE KeyField = Something[/tt]

Have fun.

---- Andy