transfertext

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

I have the following...

Docmd.TranferText acExportDelim,, NewFile, NewPath & ".csv"

The NewFile and NewPath are variables/string, and determined at runtime.

I am noticing that the NewPath and NewFile are being determined correctly Ii
displayed them in a messagebox).. its just not the csv file is not being
created in the right place or at all!! Am I dong something wrong?

thanks in advance,
geebee
 
Is NewFile an Access table or query? Do you have the rest of the path
created properly in NewPath? It should look like:

"C:\Myfolder\myfile" & ".csv"
 
Back
Top