Versions des environnements
Hi,
In Visual Fox pro I used to transfer data from DBF tables to Sql server. Before copying I could edit the data in Foxpro like
1. Connection to foxpro tables
CREATE CONNECTION SCRUB CONNSTRING "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceDB=" + source_path_LU + ";SourceType=DBF "
2. creating view
Create SQL VIEW rv_UB;
connection SCRUB;
as SELECT * FROM &gcTable
Now I want to do the same in C#. I could connect correctly but doesnot know how to access data from foxpro table. Should I use View like above..if yes how or is there any better method?
string source="Provider=vfpoledb:1;Driver={Microsoft oledb Provider for FoxPro};Data Source=c:\\LH\\;Source Type=dbf";
OleDbConnection oledbconn1=new OleDbConnection();
oledbconn1.ConnectionString =source;
oledbconn1.Open();
Thanks for your help
Bharat
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