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

Maybe this?

strFileName = CurrentDBDir() & "\" & "Y_ta.TXT"

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Wednesday, January 05, 2011 9:41 AM
To: Access Developers discussion and problem solving
Subject: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com