Import Spreadsheet in Access Database

G

Guest

Please help. I have a spreadsheet that is used to import data in access
database. I opened MS Access -> Get External Data -> Import, then I got the
following error message:
"The wizard is unable to access information in the file C:\...Test.xls.
Please check that the file exists and in the correct format"

If I opened the spreadsheet, then it's ok. I did not get the above messge.
If I closed the spreadsheet, then the message appears.

Please help!!!

Thanks...
 

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

I can not import any Excel Spreadsheet! 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import wizard unable to access information for Excel spreadsheet 0
Import Spreadsheet Wizard 10
Import Excel spreadsheet. 11
Import Spreadsheet Wizard Subscript out of Range 0
Access 2007 import failure 4
can't import Excel spreadsheet 1

Top