Question Locked

uploading data

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am not a proficient VB programmer. I am having a problem writing a code to upload data from one table to another. The tables are in different databases. Also, the fields are different e.g. Id in one table and IdNo in the table. I am using SQL database.
Please help.

2 replies

by thumbsup2

Extract all from table 1 into an array, then insert into table 2 by reading the array. The insert command will list the table 2 field ID's.

This discussion is closed to new replies.