I am trying to Import an Excel 97 file into Access 97 using the Import Wizard.<br>The error message is:<br>"An error occurred trying to import file 'C:\Book1.xls'. The file was not imported".<br>I've imported files many times before with success. This one Excel file will not import into Access. I've saved it under different names, copied the sheet I want into a new workbook, and other tricks to try and get around this.<br>Is there something wrong on the Excel side or the Access side?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error Using Import Wizrd for Excel
- Thread starter KenG
- Start date
It would appear that something is wrong with that particular .xls<br>Create a blank Speadsheet and copy and paste the cells from the bad one to the new one, then save the new one and try to import it into Access.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
- Thread starter
- #3
This brings a new meaning to bad data 
<br>I copied and pasted the cells into a new workbook and tried to import. I get the same error message!<br>I tried a few other things - reformatting, saving in yet another workbook, and importing without using the first row as field names. The only thing that finally worked was to delete the first row and then manually type them back in a new first row. I don't know why this worked, but maybe someone has an idea. At least I know what to try if this happens again.<br>Thanks for the suggestion.<br>
<br>I copied and pasted the cells into a new workbook and tried to import. I get the same error message!<br>I tried a few other things - reformatting, saving in yet another workbook, and importing without using the first row as field names. The only thing that finally worked was to delete the first row and then manually type them back in a new first row. I don't know why this worked, but maybe someone has an idea. At least I know what to try if this happens again.<br>Thanks for the suggestion.<br> - Status
Similar threads
- Locked
- Question