Unanswered: How to create a .dbf file using VB 6.0
can anyone help me creating a .dbf file using vb6.0. do i need to add a dll or what reference do i need to add so that i can create a .dbf file. im new w/ VFP.
what i did now is i convert my excel report program to .dbf file but still it wont work. heres my code maybe u can revise this one.
Dim rs2 As New ADODB.Recordset
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
Dim nrow As Integer
Dim SUM As Integer
Dim DLYSALE As Double
Dim pathz As String
Dim filename As String
SUM = 0
nrow = 3
Set rs2 = New ADODB.Recordset
' Create a connection to SQL.
SQL2 = "SELECT * FROM SALES WHERE TRANDATE BETWEEN '" & datef & "' AND '" & datet & "'"
Also, keep in mind that most developers moved away from DAO to ADO years ago. (the last time I even looked at an app with DAO was 2000 or 2001...)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert