I have a folder which contains a number of excel spreadsheets. I want to know if there is a way of extracting the data in these spreadsheets to update fields in a MS Access database.

I'm sure there will be a way around this using VBA code but am not sure, so any help would be greatly appreciated.

Many thanks

The short answer is "Yes."

The longer answer depends on how you want to get the data. Do you want to import whole spreadsheets into existing or new tables, or take values from specific fields, or search the worksheets for values and get the data wherever you find those values, etc?


mmcdonal

I will need to take values from specific fields.

Basically I have external clients that send in a form generated on MS Excel. Each form they send in will have a unique number which matches up to an entry in the primary key field of the MS Access database.

I would like to be able to extract any data from these forms, that differs from the info in the matching record, into the database.