Share via

Import Spreadsheet Wizard Error

Anonymous
2015-11-17T13:33:17+00:00

I have exported an empty table to an Excel spreadsheet format. I then copied and pasted approximately two thousand records into it so I can then import the table into my database. When I attempt to import the excel spreadsheet data into my table I get an error message telling me that a field (that is in the table) does not exist. Can anyone give me an idea what I am doing wrong? Is there a limit on the amount of records that can be imported?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-11-18T15:53:17+00:00

    If Access says a field does not exist when it does indeed exist it usually means an indexing problem. Start with compacting the database. If that doesn't fix it import everything into a new, blank database. Also compare the field names to what is used in the spreadsheet.

    If you still get this error try renaming the field. Make sure it does not have any spaces and is not a reserved word like "Date"

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2015-11-18T14:46:37+00:00

    That's exactly what I am doing. I am choosing append and that is when I am getting the error message.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2015-11-18T16:01:12+00:00

    Why don't you try importing the data to a new table and then compare the new table against your current table.  You may spot your problem.  Once you've done that, you can simply create an append query to append your new table's data to your intended target table.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-11-18T00:13:28+00:00

    You need to click 'External Data' on the ribbon and select Excel.  Find your Excel file and then either import, append, or link.

    Was this answer helpful?

    0 comments