Appending into an existing Table

K

Kevin

In Access 2003 I have a template worksheet which I import into an existing
access table using the Wizard. Normally, I highlight the file and check that
the first row are data labels then import or append the new data. Using the
same template, I have tried to append the same data base using the same
template; however, the data base is now converted to Access 2007. I get an
error message" Subscript out of Range".
 
J

Jeanette Cunningham

Kevin,
this sort of error for an import often means that there is a mismatch
between the number and/or name of columns in the excel worksheet and the
number and/or name of fields in the table you are importing into.
If you want to troubleshoot it, import the 1st field only. If that one went
OK, try the next field, eventually you will find which column/field is
causing the problem.

Jeanette Cunningham
 

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

Import errors importing Text into existing table, header vs no hea 3
Import new data and replace old data in Access table. 4
Import Table Wizard not working 1
>> Importing from SQL 6
VBA - retrieve data on last create named range from previous inserted named range 0
Access import from Excel - Append & Update simultaneously 1
Best way to import text file into existing table on a daily basis 15
Subscript out of range messge while importing from Excel to append 8

Top