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