Problem linking textfiles

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem importing data form textfile 3
docmd.transfertext using filename with .1 or .2 extensions 2
Linking spreadsheets to Word 4
Linking to FoxPro Databases with Access 2003 2
A97: Create link specification from code? 1
Access Linking to DB2 Tables very slow 5
Problem linking to SQL tables in Access 4
Text File Import Problem 1

Top