rangudu_2008
10-16-2011, 11:38 PM
Hi,
I'm looking to build a VBA module thru which i can search contents of a Visual Foxpro Database (.DBF File) and return the search results to an excel sheet. The foxpro file contains about 7 columns and search is done using simple SQL queries with "=" or "LIKE" operators. The DBF file contains about 1.6 crore records.
The base data actually exists on a SQL Server, however my client (for whom i'm buliding this utility) doesn't have SQL installed in their machines and so deployment would be a problem if i code using VBA forms and ADO / DAO connectivity.
I came across the below KB submission by tommy bak (http://www.vbaexpress.com/forum/member.php?u=236) (Thanks Tommy!! :friends:) wherein i can search using SQL queries.
Querying workbook with SQL (http://www.vbaexpress.com/kb/getarticle.php?kb_id=88)
The above KB fulfills my requirement, however instead of searching with the excel file, i need to search from the Foxpro database. Can someone guide / teach me how to do it?
Regards
Sarang
I'm looking to build a VBA module thru which i can search contents of a Visual Foxpro Database (.DBF File) and return the search results to an excel sheet. The foxpro file contains about 7 columns and search is done using simple SQL queries with "=" or "LIKE" operators. The DBF file contains about 1.6 crore records.
The base data actually exists on a SQL Server, however my client (for whom i'm buliding this utility) doesn't have SQL installed in their machines and so deployment would be a problem if i code using VBA forms and ADO / DAO connectivity.
I came across the below KB submission by tommy bak (http://www.vbaexpress.com/forum/member.php?u=236) (Thanks Tommy!! :friends:) wherein i can search using SQL queries.
Querying workbook with SQL (http://www.vbaexpress.com/kb/getarticle.php?kb_id=88)
The above KB fulfills my requirement, however instead of searching with the excel file, i need to search from the Foxpro database. Can someone guide / teach me how to do it?
Regards
Sarang