VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

dBase Viewer

Foundations Software  (5 Submissions)   Databases/Data Access/DAO/ADO   Visual Basic 5.0   Beginner   Wed 3rd February 2021

View the contents of a dBASE file (.DBF). Good example of how to use ListView and ADO together. Code can be easily modified to handle MSAccess files or even CSV files. Only thing particular about dBASE as opposed to other databases is the manner in which the Connection and SELECT strings are created.
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\somepath"
Then specify the filename in the SQL statement:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
Hope someone finds this useful ... Cheers

Side Effects
None that I know of but please report any bugs

Rate dBase Viewer (5(5 Vote))

Download dBase Viewer

dBase Viewer Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters