It would be more efficient and require less effort to use linked tables.

--
Michael Hopwood (Phobos)


"onedaywhen" wrote in message
om...
...or run a query in MS Access to create a new Table e.g.

SELECT *
INTO MyNewTable
FROM [MyWorkSheet$] IN 'C:\MyWorkBook.xls' 'EXCEL 8.0;'


"Michael Hopwood" wrote in message
...
Why not create linked tables in Access that contain your spreadsheet
info,
then all your data-importing is handled through SQL.

--
Michael Hopwood (Phobos)


"Eric" wrote in message
...
We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric