Data from Excel to Acces

Hey,

What i want to do is sumhow get all the data from many spreadsheets in excel and put then into different tables in access, once that is done i want to be able to have access somehow refer back to the excel workbook and see if any prices have been updated and if so update the price in the database.

Is this possible,

Thanks in advance

To do the first thing is easy: import your spreadsheets into Access. You can load the data directly from Excel into Access using SQL*XL, an addin for Excel that allows full database access directly from Excel.

To do updates is more tricky. Somehow you must find a way to see whether the Excel data is different from the Access data. There is a way to do this in SQL*XL but it is a bit longwinded.

Hope this helps,

Gerrit-Jan Linker
www.oraxcel.com (SQL*XL)

I would just link into the xls from Access:
File\GetExternalData\LinkTables
A browse window pops up, just change file type to xls and browse to where the file resides. If you make a change in the Excel file
it will show through the link table in Access.