>I have a database under it has several tables. Can you please kindly provide info on running just the queries against .dbf table files.
>
>select * from docindex.
>
>how to run above query and extract export data into excel file or a csv file.
>
>My objective is toextract data from tables and export to sql server.
>
>I worked on fox pro in 2001, sice then switched to sql server database with dot net applications.
>
>now i have been tasked to extract one of the old database of fox pro we have few tables data need to be extracted to sql server.
>
>is it possible to extract first data to excel files and then will impot excel files into sql server.
>
>Thank you very much for the helpful info.
Sure:
You even do not need queries if you want to export everything to Excel :-)
USE DocIndex
COPY TO DocIndex XL5
BTW you can use select * from OPENROWSET on SQL Server side.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.