VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



dBase Viewer

by Foundations Software (5 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (5 Votes)

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

Download dBase Viewer

Download dBase Viewer (4 KB)

dBase Viewer Comments

No comments have been posted about dBase Viewer. Why not be the first to post a comment about dBase Viewer.

Post your comment

Subject:
Message:
0/1000 characters