problems importing data from excel spreadsheet

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.

Thanks,

Dave
 
A

aaron.kempf

what is your path.. a URL?
you really should lose the training wheels and use Access Data
Projects.

SQL Server has real ETL tools; like DTS and SSIS for example.

MDB is for retards.

-Aaron
 

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

Grouping Names in Mail Merge 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
problems importing excel 2003 data into access 2003 1
Importing excel files into Access 3
Import Excel Spreadsheet 1
How to import Start/Finish Data from Excel 1
Import Excel Spreadsheet 1
I can not import Excel Spreadsheets 3

Top