Acess Import Routine

[Brian Branco]

I have an Excel spreadsheet with the following
Code Description
0001 Brian
0002 Ted
0003 Sam

Does anyone have a routine that will

1) Prompt for a file name (Excel)
2) Read the contents into a temporary table
3) Update a table with the data
a) If the key field is found, update the description
b) If the key field is not found, add the key field
and update the description.

I am new to access, but not new to programming...

Thanks in advance,

 

[Douglas J. Steele]

For part 1, see http://www.mvps.org/access/api/api0001.htm at "The Access
Web".

For part 2, use the TransferSpreadsheet method. If you can't find it in the
Help file, check
http://msdn.microsoft.com/library/en-us/off2000/html/acmthactTransferSpreadsheet.asp
(don't worry that it says Access 2000: it's the same in all versions)

For part 3, write an Update query.