problems importing excel 2003 data into access 2003

D

Dave F

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
 
R

Ray Cacciatore

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

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

Access 2003 and excel 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Import errors from Excel 3
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
problems importing data from excel spreadsheet 1
Importing XML Data in Access 2003 1
Error importing to Access - file was not imported 1
Problem with Excel Import Wizard 1

Top