2013/01/25

DBF quick query tool

I created a simple tool for querying *.dbf files.

Two ways to query *.dbf:
1.Free table directory (No *.dbc) (OleDb)

Connection string will be like this:
Provider=vfpoledb;Data Source=C:\temp\WLAB32\;Collating Sequence=machine;

2.Database container (.DBC)

Connection string will be like this:
SourceDB=C:\YourPath\YourDbName.DBC;DRIVER={Microsoft Visual FoxPro Driver};SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes

You can download this tool from here.
You may need the VFPOLEDB driver (here)

Reference:
Connection strings for Visual FoxPro / FoxPro 2.x

No comments:

Post a Comment