Extracting data from excel spreadsheet to update records in Access Dat

[NeilPattison]

Hi guys, can someone please point me in the right direction

I'm sure there will be a way, but I cant think of it, that you can extract data from an excel spreadsheet and update/append records in an MS Access database using VBA code.

Any help would be gretaly appreciated. Thanking you in advance
__________________
----------------------------------------------------

Cheers Neil

 

[Remou]

There are a variety of ways, depending on the format of the spreadsheet. There include:

- Automation
- Transferspreadsheet
- Linked tables and queries.