Insert into SQL from Foxpro

[ddg]

I have a recordset in my VB6 app that was created using ODBC and I would like to insert the data into a SQL db table. I already have the target Db & table setup. What is the fastest way to accomplish the data transfer? Can I do a Select into using the ODBC recordset as my source?

Thanks

[John Bell]

Hi

You may want to look at creating a linked server on the SQL Server, and then the SELECT INTO will be possible. Alternatively if it is only data you require to be moved a DTS package may be used.

John

"ddg" <dd*****@comcast.net> wrote in message news:JW4rb.145833$e01.505036@attbi_s02...
I have a recordset in my VB6 app that was created using ODBC and I would like to insert the data into a SQL db table. I already have the target Db & table setup. What is the fastest way to accomplish the data transfer? Can I do a Select into using the ODBC recordset as my source?

Thanks