Solved

Importing data into an existing table

Posted on 2011-03-17
2
212 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:tols12
2 Comments
 
LVL 6

Accepted Solution

by:
rbgCODE earned 250 total points
Comment Utility
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.  
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
Comment Utility
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
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now