SQL Server data export to dbf

The place where ProMatrix users can post coding tips and utilities they create.

SQL Server data export to dbf

Postby JessicaLawson » Sun Jun 13, 2010 4:25 pm

Hi, This is first time for me using sql server data,
I have try to access and I can see the data on the form.
how to export the data to dbf?
please advise

Thanks,
Ben
JessicaLawson
 
Posts: 79
Joined: Sun Jun 13, 2010 1:23 pm

Re: SQL Server data export to dbf

Postby JessicaLawson » Sun Jun 13, 2010 4:25 pm

Hi Ben,

You are posting your messages in the wrong group. This kind of messages should be posted in the Developers newsgroup so you can have more answers to your question.

Basically VFP creates a CURSOR when accessing data in other databases, so you treat this cursor as you would treat any table.
Check the VFP commands for DBF(), CURSORTOXML()/XMLTOCURSOR(), COPY TO, etc which may help you get the result you want.

--
Edhy Rijo
http://www.progytech.com
Bronx NY
ProMatrix MVP Life
JessicaLawson
 
Posts: 79
Joined: Sun Jun 13, 2010 1:23 pm


Return to ProMatrix User Library

Who is online

Users browsing this forum: No registered users and 2 guests

cron