problems importing data from excel spreadsheet

[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.

Thanks,

Dave

 

[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