Problem linking textfiles

  • Thread starter Thread starter a
  • Start date Start date
A

a

Hi,

We are migrating from Access 97 to Access 2003.


DoCmd.TransferText acImportFixed, "HDMARTPC", "tbl3031_HDMARTPCDAT",
"C:\HdbDatabase2003\hdmartpc.dat"
In our database we are using a couple of linked tables to textfiles. We have
created import/export specification to describe the fields and fieldtypes in
the textfiles.
It seems that in Access 2003 it is no longer possible to create a link to a
textfile with a suffix .dat
I have



If I rename my sourcefile to test.txt, I can create the link and open it.
But if I rename
 
Back
Top