Select from DB2 DB and insert into MS Access DB

[mjd430]

Hello,

I need help! I am brand new to VB.net after programming in Powerbuilder for the past 5 years, so I am kind of lost. I am trying to Select rows from a DB2 database and insert those rows into an MS Access database (with the same schema in both db's). I can connect to both DB's, and even select the data I want from the DB2 DB, but I don't know how to insert the data into Access. I was hoping I could do an "Insert into...Select from" statement, but I get the feeling I can't. Can anybody help me? I've been stuck on this for the past few days and could really use some guidance!

Thanks in advance for any help...

 

[cjard]

read the db2 data from the database into a db2 dataset
you say the access database has the same schema, so make an access dataset on the client side, and then:

accessdataset.Merge(db2dataset)

then upload the data into acces. FOr more info, read the DW2 link in my sig