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

It sounds like you are getting a special character in there.  Is there a # in the table name?  In a 
field name?  In a path?

John W. Colby
www.ColbyConsulting.com

On 1/5/2011 10:41 AM, Lawrence Mrazek wrote:
> 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