Error linking to excel file

B

BlueWolverine

Hello,
MS Access 2003 on XP Pro.

I am trying to get some tables into acces from EXCEL Sheets (preferably as
linked tables, though importing would be fine as well.)

As soon as I do it, I get an error

The file is what I believe to be in the right format (top row is headers,
the rest data.) and it definitely exists.

HELP!!!

Thanks you
 
B

BlueWolverine

I got the error trying to do the same thing with the files on my desktop.
I've never had a problem linking files on this computer before.
 
B

BlueWolverine

I think I found the error. These are report pulls from a web based system
and some how I think they were saved as HTML instead of excel, even though
the extension is .xls. SAVE AS excel fixed it.
 

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

Not able to create linked table from Excel (when Excel is closed) 1
Linking excel files to access - format changes - Type mismatch err 1
linking to an .mde file from .adp 2
Help needed in linking to tables using Access 2007 1
Excel How to Fix Damaged Excel File That Won't Open? 3
Conneting to SQL server, Need advice 3
Error 8961 when linking/importing a dbf 1
Linking Table Error 3

Top