Solved

Tab delimit

Posted on 2004-04-05
3
935 Views
Last Modified: 2012-08-13
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
Comment
Question by:wshore
3 Comments
 
LVL 7

Expert Comment

by:donpricejr
ID: 10762452
Try changing "acExportDelim" to "acExportFixed".

-Don
0
 

Author Comment

by:wshore
ID: 10762679
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
 
LVL 2

Accepted Solution

by:
joshco earned 100 total points
ID: 10762749
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question