Hi James
Sorry for sounding ignorant but what is ISQL?
Thanks
Simon
>Simon,
>
>You can use the OUTPUT statement to extract data in a number of formats. One of the is foxpro which gives you a 2x type dbf file.
>
>Select * from table ;
>output to c:\file.dbd format foxpro ;
>
>This will only work using ISQL. You can also automate ISQL with command line options so the extracts can be part of a batch file.
>
>Using VFP you can do about whatever you want through ODBC. Just remember that vs5.5 has to have an client app running to allow ODBC to connect. If you have a lot of data to output the option above is much faster.
>
>
>>Hi
>>
>>I have a customer who wishes me to extract some data on an on going basis from an app. I can use the built in export function in the application with some work arounds but in the process I discovered that the application was using SQL Anywhere 5.5 so I thought it would be better to use VFP to extract the data because I could automate the whole thing.
>>
>>Not being familiar with SQL Anywhere I wondered if some current users might give me a little information on how and what is required to export data from SQL Anywhere into VFP tables for further analysis.
>>
>>Thanks
>>Simon White
Simon White
dCipher Computing