FoxPro (DBF) files x VB

JustAGuy
01-12-2004, 01:01 PM
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!

Shurik12
01-12-2004, 01:58 PM
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.

JustAGuy
01-12-2004, 02:19 PM
Thanks!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum