FoxPro (DBF) files x VB

Hello,

I am going to write a simple application to convert FoxPro databases to SQL Server format. Well, everything I need to know is:

1) How can I connect VB to FoxPro data files (*.DBF)?
2) How can I read data from DBF files to a recordset?
3) There is some application where I can browse/view structure of DBF files?

Thank you very much!

Hi,

As for the first two questions:

1)
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForVisualFoxPro

or
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForVisualFoxPro

2) Having openned the connection you can open an ADO recordset.


Regards,
Shurik.

Thanks!