• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 955
  • Last Modified:

Tab delimit

I need a file exported as text using tab-delimited, no quotes around text.  I created a spec in the "Export Wizard", called 'TabExportSpec' and ran the following:

DoCmd.TransferText acExportDelim, TabExportSpec, "ActionCodeResults", "C:\MFAtest\ActionCode2.txt", False

Access ignored the spec I created and used comma's and quotes anyway.  Apparently my spec is in the wrong place.  What Have I done wrong?

Warren Shore
0
wshore
Asked:
wshore
1 Solution
 
donpricejrCommented:
Try changing "acExportDelim" to "acExportFixed".

-Don
0
 
wshoreAuthor Commented:
Don:

This still produces an error, in this case 2511 "...action requires a specification". That's what I thought 'TabExportSpec' was for.  Is TabExportSpec in the wrong place?  Why isn't it recognized?

Warren
0
 
joshcoCommented:
put "Tabexportspec" in quotes, right now you are passing it a null for the value which suggests to it that it doesn't need to use a spec.

DoCmd.TransferText acExportDelim, "TabExportSpec", "ActionCodeResults", "C:\MFAtest\ActionCode2.txt", False

-Josh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now