tylerjones
Programmer
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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
from sql server to fox pro
- Thread starter tylerjones
- Start date
- Status
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.
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.
- Thread starter
- #3
tylerjones
Programmer
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.
This might be a helpfull link for you to have a look at
Rick.
Rick.
- Status
Similar threads
- Locked
- Question
