Cannot import of link from Excel

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

Guest

I'm trying to import data from excel, but I'm getting the error message "The
wizard is unable to access the information in the file. Please check to make
sure that the file exists and is in the correct format. I've imported from
Excel in the past with no problems. Any ideas as to what's going on? Any
help is appreciated!
 
Is it a long path to the EXCEL file that you're importing?

Does the EXCEL file have an .xls extension?

Is there a password protection on the EXCEL file?

Is the EXCEL file indeed an EXCEL file?

Is the EXCEL file closed when you try to do the import?
 
Thanks for the reply Ken. In answer to you questions:

1. Yes, it is a long path actually. Didn't realize that could be a problem
and I'll move it see if that fixes the problem.

2. Yes, it has an .xls extension

3. No, no password protection

4. Yes, it is definately an excel file

5. Yes, the excel file is closed when I try the import.

I'll post again after I see if moving it fixed the problem.
 
Okay, I tried moving the files. Still no luck. If nothing else, I can copy
from excel and paste manually into an access table, right? I was hoping to
avoid that because there is a lot of data to work with.
 
In many cases, it's possible to use Ctrl-c and Ctrl-v to copy/paste data,
although it may copy incorrectly with respect to data type/format.

How are you doing the import -- via File | Get External Data | Import ? or
by a macro/VBA using TransferSpreadsheet?

Are there any empty rows at top of spreadsheet? Are there any merged cells
in the spreadsheet?
 
Thanks for keeping up with this Ken. I really appreciate it.

As for importing the data, I've been trying the Get External data route.
I've never used the Transfer Spreadsheet process, but I'll give that a try a
bit later this morning and see if it works. There are no empty rows and no
merged cells in the spreadsheet at all. It's pretty simple.
 
Back
Top