change import location

[Sardamil]

In my import script I've got several lines like this:

DoCmd.TransferText acImportDelim, "ABNTB002 Importspecificatie", "ABNTB002", "l:\tool RVS\ABNTB002.txt", True, ""

I would like to change the import location to be able to import files in any directory, ie the directory the database is in. Is this possible?

Anything that can go wrong will go wrong

Window to my world

 

[Remou]

The directory the database is in is:

CurrentProject.Path