Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • 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
0
tols12
Asked:
tols12
2 Solutions
 
rbgCODECommented:
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
 
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
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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