I am trying to move data from my ACCESS database to my SQL SERVER that is hosted somewhere on a server using Visual Basic. Should I use DAO ADO ADODB for the fastest upload? And wil lthe standard recordset update method work?

How does this involve DTS?

You may want to try posting to a VB And/Or Access group instead

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"DataJunkie" <anonymous (AT) discussions (DOT) microsoft.com> wrote

for the fastest upload? And wil lthe standard recordset update method work?