P
pop
i have recently migrated to windows xp and now get an error 3011 (The
microsoft jet database engine could not find the object "EzyChart.txt) in vba
routine that uses 'connect' property to import text data.i have been using
this routine for several years without a problem with windows 95.
The routine fails on the last line of code listed below.
'ConnectOutput dbstemp, _
"CSVTable", _
"Text;DATABASE=C:\importdocs;TABLE=EzyChart.txt", _
"EzyChart.txt" '
'Sub ConnectOutput(dbstemp As Database, _
strtable As String, strConnect As String, _
strSourceTable As String)
Dim rstLinked As Recordset, rsttd1 As Recordset
Dim intTemp As Integer
Dim strasxcode As String, stropenprice As String, strhiprice As String
Dim strloprice As String, strcloseprice As String, strvolume As String
Dim strdate As String
Set tdflinked = dbstemp.CreateTableDef(strtable)
tdflinked.connect = strConnect
tdflinked.SourceTableName = strSourceTable
dbstemp.TableDefs.Append tdflinked'
I have verified the pathway is valid using 'search' and the schema.ini file
exists and contains a valid entry for this file.
desperately in need of a solution for this problem.
microsoft jet database engine could not find the object "EzyChart.txt) in vba
routine that uses 'connect' property to import text data.i have been using
this routine for several years without a problem with windows 95.
The routine fails on the last line of code listed below.
'ConnectOutput dbstemp, _
"CSVTable", _
"Text;DATABASE=C:\importdocs;TABLE=EzyChart.txt", _
"EzyChart.txt" '
'Sub ConnectOutput(dbstemp As Database, _
strtable As String, strConnect As String, _
strSourceTable As String)
Dim rstLinked As Recordset, rsttd1 As Recordset
Dim intTemp As Integer
Dim strasxcode As String, stropenprice As String, strhiprice As String
Dim strloprice As String, strcloseprice As String, strvolume As String
Dim strdate As String
Set tdflinked = dbstemp.CreateTableDef(strtable)
tdflinked.connect = strConnect
tdflinked.SourceTableName = strSourceTable
dbstemp.TableDefs.Append tdflinked'
I have verified the pathway is valid using 'search' and the schema.ini file
exists and contains a valid entry for this file.
desperately in need of a solution for this problem.