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
 
C

Chris O'C via AccessMonster.com

This happens when the file name extension isn't associated with Excel.
Change it to .xls.

Chris
Microsoft MVP
 
C

Chris O'C via AccessMonster.com

Do you get this error only with the xls files in this folder or
do you get this error when you link or import any other xls files with the
import wizard?

Chris
Microsoft MVP
 
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.
 
C

Chris O'C via AccessMonster.com

Maybe there's a problem with these files. You don't get the "SYLK format"
message when you open the spreadsheets in Excel, do you?

Can you create a new, simple spreadsheet with headers (3 or 4 columns and 2
or 3 rows) as an xls file and link to that?

Chris
Microsoft MVP
 
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.
 
Top