Get data from SQL Server DB and write to Access DB
Hi,
I work in VB.NET and am not familiar with VB and record sets.My problem is,
I need to
1=> Read data from a SQL Server database using VB 6.0
2=> Write the data to an Access database.
I have done the first part, i have read the SQL Server DB and have the data in a recordset, now how do I write it into an Access DB?
In know if I try it myself I will be able to figure it out, but the time is very less and Iam also working on another project!
Thanks in advance.
Re: Get data from SQL Server DB and write to Access DB
If you can read the data from SQL already then all you need is some INSERT INTO sql statements to add the records to the Access db.
Are you using ADO? Are you able to connect to Access?
Re: Get data from SQL Server DB and write to Access DB
Yep Iam using ADO, but have not connected to Access DB yet.