When I try to execute this line of code:
DoCmd.TransferText acExportDelim, "XML_RaterExport", "tblRates", "C:\Temp\Rates.csv", True
I get an error --
Run-time error '3011': The Microsoft Jet database engine could not find the object 'Rates#csv'
Note that somehow Access is deciding that the "." is a "#" ???
The same thing happens with a ".txt" extension. I was originally passing the output filename via a string variable, but I get the same results even hard-coded as above.
I'm stumped -- experts?
Thanks in advance!