469,111 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

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

Jul 20 '05 #1
1 4795
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by kungfukittens | last post: by
13 posts views Thread by Simon Bailey | last post: by
1 post views Thread by David Sorber via AccessMonster.com | last post: by
12 posts views Thread by Roy Gourgi | last post: by
7 posts views Thread by z71mdridin | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.