Linking Multiple Excel Files to One Access Database

M

MsCitiCenter

I am trying to link several excel files into one Access database. I am
working with Access 2003. I have done this before and it has worked, but for
some reason I keep getting an error that says it cannot do the import.
 
J

Jeanette Cunningham

Hi,
can you link any of the excel files?

Jeanette Cunningham -- Melbourne Victoria Australia
 
J

Jeanette Cunningham

If the excel file is on a network, you may need to use a UNC path to do the
linking.
The trick is that you need to navigate to the excel file using Network
Neighborhood (My Network Places, etc. whatever Microsoft is
calling it ) instead of My Computer.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Top