Len,
There are ODBC.NET files somewhere on MSDN. These utilize ODBC data sources and create Datasets. I have used them successfully on FoxPro, Access , and pardox files. The only problem I had ws with Paradox tables that had spaces embedded in the field name.
Hope this helps.
Ken
>Problem de jour!
>
>On a regular basis I need to be able to open and read incoming FoxPro 2.6 tables within a VB.NET application (the 2.6 tables are coming from end-user VFP6 applications - they are 2.6 files because of a legacy SAS application) The original application that performs this operation is written in VFP6 and our current contract requires us to move everything into .NET -- I am in the beginning stages of getting my feet wet with .NET and the only method that I see thus far is ODBC (I'm not really thrilled about using it).. OLEDB only works if I have an intermediate routine that pushes the 2.6 files into DBC and the JETOLEDB supports just about everything (dBase, Paradox, etc..) except FoxPro.. nice huh?
>Any suggestions?
>
>-- Len Wooden
Ken Wardwell