VBA Code to Import Text Files 2

[Hattrick16]

I want to import text tables into an Access DB, The files will always be in the same directory as the Access DB. The DB is an application to be copied by the enduser to thier part of the network with the proviso that the data files are put in the same DIR.

The Do command requires a hard coded path so this is not a viable option.

How would you write this code?

 

[Crowley16]

docmd.transfertext and currentproject.path...

--------------------
Procrastinate Now!

 

[Hattrick16]

Thanks Crowley16

Can you provide me with a little more detail as I am a beginner. A code sample would be helpful

 

[EnergyTed]

This should help hopefully.

DoCmd.TransferSpreadsheet acImport, 8, "Name of file", "The path of where to find the file", True

The 8 stands for the type of file you want to import, 8 for example relates to a .xls file type. And True is whether field names are included or not.