Recent content by genny

thanks a lot . It did not know of CurrentDB().Name for the path. it works perfectly.

I am trying to import a text file using the command docmd.transfertext this is my code: DoCmd.TransferText acImportDelim, "IMPORT", _ "AMEX", "volbyclass-amex.txt", -1 my text file is in the same directory as my access database but it doesn't work. it gives me an error that it cannot find...