Excel to Access link

J

Janis

If you have to import data from multiple spreadsheets on multiple servers
what is the best way to do it? Do you link Excel to Access on the network or
do you use odbc?

If you have 3 users of the above database do you use filesharing or do you
use Active SErver pages?

There is a lot of data more than 15,000 records in Excel.

thanks,
 
P

Pete

Are they going to redo it again and again, Access has native import for
excel so it is easy to link to the file and import into tables. Question
is, is this a one time import or are you going to do it again and again.
Excel files are not that large and can be mail in. If your going to do it
over and over then an small module could be setup to a button. Still just
import using some import templates. I would not use ODBC.
 
Top