from sql server to fox pro

[tylerjones]

I have to take data from a sql server table and create a fox pro table out of that data and then zip up that table for download. Does anyone know how to do something like this? Thanks.

 

[fluteplr]

You could use DTS (Data Transformation Services).
Create a job that exports the data to a foxpro table and then use an execute process task to zip up the file.

Or

If you want to do it from foxpro:

Create a dbc with an appropriate connection to sql server.

nconn=sqlconnect('myconnection')
sqlexec(nconn,'select * from mytable','mycursor')
select mycursor
COPY TO somefilename
!run pkzip somecommandline

I don't remember the pkzip command line syntax but I am sure you can look it up.

 

[tylerjones]

Well, I'm having a tough time learning finding DTS tutorials that are aimed at pure beginners. And also, I do not have existing fox pro tables. I need DTS to create the tables for me. Can you offer any links to sites with tutorials for beginners about DTS and this subject matter? Thank you.

 

[RickCole]

This might be a helpfull link for you to have a look at

http://www.sqldts.com/default.asp?nav=1,1,1,100

Rick.