problems importing excel 2003 data into access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using Office 2003.

I'm trying to import a data table from an Excel workbook into an Access db.
When I navigate to the XL doc and click through the dialogue box I get an
error message:
"The wizard is unable to access information in the file [filepath]. Please
check that the file exists and is in the correct format."

The file does exist, as I can open it in Excel. And the file is a .XLS
file. Any clues here as to what this message means? I've never seen it
before. This problem is occurring at work, where I recently got a new
computer with Office 2003 installed. Previously I have been using Office
2000 and have had no problems importing data from excel sheets. So I assume
there's something about Office 2003 I don't know?

Thanks,

Dave
 
How are you importing the Excel sheet into Access?
Give me more details, step by step.
 
Back
Top