fast way to copy from sql server table to access table

[sal21]

With ado and vb6 classic. I have sql table with approx 4.500.000 records. How to copy all sql records into the access table via vb6 code, and with fasted method?

[Md Marufuzzaman]

Could you let me know your target version of MS Access database and do you have any plan to do this by SQL Server DTS services via VB?

Thanks Md. Marufuzzaman

---

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

[sal21]

-access 2003. -Vb6 classic I cannot have permission Sql Server, but have only a redaing on the sql table. If for you is a god way to use DTS in vb code this solution is welcome! Yes if is possible make all wiyh vb6 classic. Tks.