Linking Multiple Excel Files to One Access Database

  • Thread starter Thread starter MsCitiCenter
  • Start date Start date
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.
 
Hi,
can you link any of the excel files?

Jeanette Cunningham -- Melbourne Victoria Australia
 
No, not a one...

Jeanette Cunningham said:
Hi,
can you link any of the excel files?

Jeanette Cunningham -- Melbourne Victoria Australia
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Linked Excel File won't update 1
unable to work in an excel file and an access file at the same tim 2
linking tables and relationships 3
Link File 1
Import multiple Excel tabs into access 4
Query linked to Excel doesn't work 5
Linking to a mainframe database 10

Back
Top