Extract data from an excel spreadsheet to update/append records

[Neil1234567]

Hi guys, I'm quite new to this so any help would be greatly
appreciated.

I need to be able to extract data from an excel spreadsheet, and
update records in an MS Access database.

I'm sure there is a way of doing this via VBA code but could someone
please point me in the right direction, as I've got a mental block and
can't find where to start.

Thanks in advance

 

[Guest]

Have you tried linking to your Excel spreadsheet? I usually create a named
range in the spreadsheet first, and then pick this named range in the link
table wizard. You can then use this linked table as a source of data for an
update or append query.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________