troubleshooting Question

how to read .dbf file from delphi 7 ?

Avatar of aldahan
aldahan asked on
Delphi
25 Comments3 Solutions7505 ViewsLast Modified:
hello every body,
i want simply to connect and retrive data from .dbf fie. i could by your help make a connection to that folder but when ever i couldent retrive data can you help me ?
here is my code for connection
 var
  strDBFolder: String;
  tmpStringList, tmpStringList2: TStringList;
  intX: Integer;
begin
  tmpStringList := TStringList.Create;
  tmpStringList2 := TStringList.Create;
  strDBFolder := 'C:\Program Files\FingerTec\TCMSv2';
  ADOConnection1.Close;
  ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +
                                      strDBFolder +
                                      ';Extended Properties=dBASE IV;User ID=Admin;Password=;';
  ADOConnection1.Open;
  ADOConnection1.Connected := true ;
  ADOConnection1.GetTableNames( tmpStringList );
   showmessage(tmpStringList.Text) ;
ASKER CERTIFIED SOLUTION
peteratsaab

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros