Linking to a delimited text file

[rmchung]

How do I programmatically create a link to a delimited text file using a defined file schema?

 

[mymou]

Is this what you mean?

DoCmd.TransferText SpecificationName:=strImportSpecification, _
TableName:=strTableName, FileName:=strSourceFile


Stew

 

[rmchung]

Stew,

The coding you have is if I wanted to import a text file into Access. Instead I just want to create a linked table. It's easy to do using the wizard - File, Get External Data, Linked Tables, select my text file, and tada, I have a link to my text file. I want to do what the wizard does, but in code. Hopefully that makes it clearer. Thanks for the input though.

Rye

 

[mymou]

Rye

Details.

Try adding - never tried it but look like it could work.

TransferType: acLinkDelim


Stew

 

[rmchung]

thanks stew, it worked. Funny how I use that transfertext method quite a bit, but never knew it had the acLinkDelim. I guess I just overlook it all the time. Thanks again!!!

Rye