Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to run queries against table .dbf
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement