Import to Access
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
|