Web Development



uploading data

By nickndegwa ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

re: getting the data

by ThumbsUp2 In reply to uploading data

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.

Related Discussions

Related Forums