transfertext

[geebee]

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

 

[Arvin Meyer [MVP]]

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"

 

[geebee]

nevermind i figured it out