• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Importing data into an existing table

I created a table in Access.
Now I am trying to import the same data (or close) into the table to refresh the data.  When I choose the file and then the table to import into, I get a "Subscript out of range" error.  This is on the last step just as it is getting ready to
2 Solutions
Subscript out of range usually means that you dont have the same amount of tables.  You have to think, if one of the fields is an auto incrementing ID then you dont need to import that in, it will auto increment on its own but without seeing any of the files or code not much more help I could offer you...

You could easily write a .net application that opens one db and just while not rs.eoof then loop through and add it, then you could even conversion-type the data for consistency.  
Jeffrey CoachmanMIS LiasonCommented:
Can you give us a bit more information about the table to be imported?
(Fields, Datatypes, ...etc)

Can you also tell us how you are doing the update?

Typically you get this error when importing Excel files when the number of fields do not match between the two tables
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now