nvwildfire
Technical User
Hello everyone, I think this is an easy question so here it is. I am creating a DBF file with ADO, the following is the code used:
Set fConn = New ADODB.Connection
fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & OPath & ";" & _
"Extended Properties=""DBASE IV;"";"
strCT = "CREATE TABLE " & OPath & "\" & OName & "(FMU SMALLINT, SCORE int, PROB double, SCHEMA1 varchar(30))"
fConn.Execute strCT
The problem I am having is that the .dbf file name is getting trunkated to 8 characters, even though OPath maybe longer than 20 characters.
I think I am just going to rename the file after it is created unless someone else knows how to resolve the 8 character limit. Any help would be greatly appreciated.
Thank you,
kgk
Set fConn = New ADODB.Connection
fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & OPath & ";" & _
"Extended Properties=""DBASE IV;"";"
strCT = "CREATE TABLE " & OPath & "\" & OName & "(FMU SMALLINT, SCORE int, PROB double, SCHEMA1 varchar(30))"
fConn.Execute strCT
The problem I am having is that the .dbf file name is getting trunkated to 8 characters, even though OPath maybe longer than 20 characters.
I think I am just going to rename the file after it is created unless someone else knows how to resolve the 8 character limit. Any help would be greatly appreciated.
Thank you,
kgk