Creating Access Table Links to Multiple Txt Files

[sibleytr]

In the past I've used the

DoCmd.TrasferDatabase acLink, "Microsoft Database" fieldName.Value &"\db.Mdb", acTable, "fieldName", "fieldName"

command to link to Mdbs in different project folders. This was accomplished with a table contanining the path of the different project folders, a form containing a combo box to select the desired project, and a button with VBA to delete the old link and recreate the new link (using the above code).

What I need to know now is can a link be created using VBA to a text file?

Can I link multiple text files given a list of path and text file names?
(\\server\share\file1...file5.txt)
(I need some type of looping to link all Txt files listed in the table.)

Any ideas would be helpfull.

 

[HitechUser]

TankHumper,

Please have a look at the TransferText action. This will allow you to link to a text file..

See the help text. Let me know if you need an example.

Good Luck...

 

[HitechUser]

Sorry (typeo) it should be TransferText Method.

Microsoft

Good Luck...

 

[sibleytr]

I finally found the KB on it but it's turning in to be more trouble then time permits, so I attacking from the VB side.

Thanks for your reply.