Windows XP TransferText error relating to FileName path

P

PerryHN

Joined
Jul 16, 2008
Messages
1
Reaction score
0
I am using Access2000 and am attempting to create a macro that will export several queries. It appears that there is a limit to the length of the FileName (& path) that can be assigned. When I put the following into the File Name and then attempt to run the macro, I get one of two error messages both of which appear to indicate a problem with the query but I can run & export the query manually without any problems. By trial-n-error I have found that if I shorten the path name, I can get the macro to run. Can anyone confirm if there is a length limit and if so, what the limit is?

C:\Documents and Settings\A012345\My Documents\Vendr\Inbound files\Access DBs & current data files\Mbr_Util_n_costs_Reg.txt

Thanks,
Perry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Length limit for FileName within TransferText? 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
TransferText Method 1
TransferText export is truncating field 2
Error 3073 with TransferText 7
Transfertext problem 2
Reading Properties from Closed Files (Office and PDF) 1
Error When Using TransferText in a Macro 1

Top