Hello,

i have a problem when i connect an access 97 database with an text file

"3000  Reserved error (-5400); there is no message for this error."

The attachment is an example of a textfile that i want to connect through vb
6.0

vb code :

strtable = "FileName"
strconnect = "Text;HDR=NO;IMEX=2;FMT=Fixed;Database=c:\temp"
strSourcetable = "MAILGV2939.TXT"

  Set tdfLinked = dbsTemp.CreateTableDef(strTable)
  tdfLinked.Connect = strConnect
  tdfLinked.SourceTableName = strSourceTable
  dbsTemp.TableDefs.Append tdfLinked

what is the solution to this problem

with kind regards
Jürgen Depoorter


begin 666 MAILGV2939.txt
M26YD:6-A=&EF(&QI=G(N.B!'5C U-S4{at}(" {at}("!2968N0VQI96YT.B X-R {at}
M(" {at}(" {at}(" {at}("!4IPTIA Consulting™.