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.