Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Importing data into an existing table

Posted on 2011-03-17
2
243 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
ID: 35162467
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
ID: 35165028
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

790 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