help with VB code in MS access module

[baggy]

Hi,

I have a table called 'test1'. It has 3 columns 'ID', 'Tag', and 'Hierarchy'.

I need to import the columns 'Tag' and 'Hierarchy' from 'test1' to 'test2' which has no data in it. I have attached the zip file with tables 'test1' and 'test2'(created a dummy table just to show how I would like the table to look like). Does anybody know how to write VB code for this. I appreciate any help from anyone.

Thanks in advance

[Rawhide]

Why are you using VB code to do this? That's like using a sledgehammer on a thumbtack.

Just create a linked table from one database to the other and run a simple insert query.

[baggy]

Hi Rawhide,

Thanks for your reply. I need to use VB code as we have completed most of our work this way. I appreciate if anybody could help me with this.

Thanks

[Rawhide]

Here's two options:

1. Create a connection to your first database
2. Query for the data you want
3. Load it into an array
4. Close the connection to your first database
5. Create a connection to your second database
6. Loop through the array inserting each record from the array into your second database
7. Close the connection to your second database


1. Create a connection to your first database
2. Create a connection to your second database
3. Query for the data you want from your first database
4. Loop through the recordset inserting each record from the recordset into your second database
5. Close the connection to both databases