[AccessD] Access 2003, Transfer Text (Fixed) not working

Hi Folks:

Not sure what the deal is, but the following code isn't working correctly

strFileName = CurrentDBDir() & "Y_ta.TXT"

DoCmd.TransferText acExportFixed, "PayRollExport", "tblPayrollExport",
strFileName, False

When I try to run, I get an error message:
The Microsoft Office Access Database Engine could not find the object
'Y_ta#TXT' . Make sure the object exists and that you spell its name and the
path name correctly.

Any ideas? I've used the transfertext function before.

Larry Mrazek
lmrazek at lcm-res.com