TransferText problem

[joel009]

I am using 2010 in 2007. There is no help that i can find for VBA 2007 on my PC and I am not allowed to get on the internet. My manager allowed me on for this.
using:
Dim strExportPath As String
Dim strImportPath As String

strExportPath = "C:\ProplannerProcessing\ProPlannerStep1\WTAP.csv"


'export rs_selProplannerOutputRecords to .csv file
' DoCmd.TransferText acExportDelim,,"tblProPlannerOutput",
DoCmd.TransferText acExportDelim, "RouteDetailImportExportSpec", "tblProPlannerOutput", strExportPath, True

and get the error #3011 stating that it can't find the object (which I expect it to make since I am using acExportDelim) "WTAP#csv".

Does anyone see what I am doing wrong???
Joel

Joel

 

[boblarson]

Don't use a # sign in your file path.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[joel009]

Bob
I am not, look at my variable, I set it to "strExportPath = "C:\ProplannerProcessing\ProPlannerStep1\WTAP.csv", I don't see a # sign anywhere. That's why I am confused, well there may be other reasons too but I don't want to go into it.

Joel

Joel

 

[joel009]

Figured it out. Access vba does not support .csv files. I exported as a .txt then rename the file with the extension .csv - wah-la

Joel

 

[boblarson]

Actually you can use csv filed but now that you mention that, I believe for them you have to use TransferSpreadsheet instead.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[joel009]

Bob,
I may check that out. Thank you.

Joel