How do I import a spreadsheet from Windows XP to Access?

G

Guest

I'm trying to import an Exel spreadsheet from Windows XP to Access 2000. At
the end of the process, there is an error message. It only states there has
been a "error" with no details.

I previously tried to import the spreadsheet, but I had both XP and 2000
version of Excel. So, I removed the 2000 version. (The program is forward
compatible, correct?) I understood it to make an easy transfer of information
either way, but wanted to keep the newest version of Excel on my pc.

What could possibly be the error here?
 
G

Guest

The version is probably not the problem. It is most likely there is a data
format problem. Usually, when there is an import error, a table will be
created that will show the errors. It will be the name of the file you are
imorting + $'_ImportErrors
Look for a file name like that, and it may help you resolve the problem.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Excel spreadsheet 21
Trying to use "Import Spreadsheet Wizard" in Access 2
Import Spreadsheet Wizard Subscript out of Range 0
Access 2007 import failure 4
Import wizard unable to access information for Excel spreadsheet 0
how to choose the tab in an excel spreadsheet to import to access 3
can't import Excel spreadsheet 1

Top