Importing Data into Access 2003 - Data disappears

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

Guest

Hello,

My office is converting from Access 2000 to Access 2003 and I am testing one
of our major databases. I have opened this database in Access 2000 file
format, and have also tried converting it to 2003 file format, and I have the
same issue.

I am trying to import data from Excel in the same manner which I always have
- nothing complex, just importing data into an existing table. The Excel
spreadsheet I am importing contains all of the same fields as the existing
Access table, except for the Autonumber. When I try to import, it gives me
the "Access was unable to append all the data to the table" error message;
however, it tells me that 0 records were lost. I've had this happen before
in Access 200 and I'd click OK to continue and all my data would be in the
table precisely as it should be.

However, now when I open the table where I'm trying to import these records,
they simply don't show up. It's as if I never even tried to import them.
I'm sure you'll need more information, but does anyone have any thoughts?

Thank you,
Adam
 
Never mind, I figured it out. For whatever reason Access 2003 didn't care
for the fact that I had blank items in my data; this hadn't been a problem
with Access 2000, but no big deal.
 
Back
Top