Solved

Connecting to a dBASE database using CODE

Posted on 1998-08-18
1
192 Views
Last Modified: 2013-11-24
Hi there,

I just want to ask how can i connect to dBASE using codes.

thanks in advance!

brandon
0
Comment
Question by:bmaranan
1 Comment
 

Accepted Solution

by:
hansbos earned 10 total points
ID: 1429516
Bmaranan,

Dim dbDatabase as Database
Dim recDbf as RecordSet
Set dbDatabase = OpenDatabase("c:\dir", False, True, "dBase III;")
Set recDbf = dbDatabase.OpenRecordset("file.dbf", dbOpenTable, dbReadOnly)
recDbf.MoveFirst
Do While Not recDbf.EOF
 'put code here
 recDbf.MoveNext
Loop
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Adding to a VBA? 6 61
Excel VBA, find a string in a column, update a cell 7 65
Display multiple images in report 12 105
Convert VB6 MSXML2.ServerXMLHTTP process to C# 2 41
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now