macro export to true text

[mart10]

i am using access 2003. I want to export the results of a query via a macros to a trues test file. When I do this it puts all sort offormating in boxes/pipes around the data. How can i solve this?

 

[papadba]

What do you expect/want as output?

 

[mart10]

just normal text on one line seperated by ,

F,TEST,99999,12234 ETC

 

[dhookom]

I expect you need to create and save an export definition. I think your macro will allow you to specify which definition to use.

Duane
Hook'D on Access
MS Access MVP

 

[papadba]

I don't currently have Access available, but is there some reason the data cannot simply be saved as a delimited text file?

Maybe this will help:

http://www.ehow.com/how_4481962_access-comma-delimited-text-file.html

 

[mart10]

no thats the issue, it allows excel and text but the text output is not what i call text, it has pipes in etc etc. try it and see. can someone help please?

 

[randy700]

What code are you using to create this file?

Randy

 

[dhookom]

mart10,
Can we assume there are no commas in your data field values?

Did you try step through the export wizard to create and save a specification that can be re-used?

Duane
Hook'D on Access
MS Access MVP

 

[mart10]

no commas in data fields

I am using macro to export. when you pick the export type text and call it a ....txt file it shows the fields in columns seperated by pipes etc Not useable

 

[dhookom]

Don't use this method. Right click the table/query and choose Export. Step through the wizard and at some point you should be able to click [Advanced]. This gives you greater control and allows you to save the specifications.

Duane
Hook'D on Access
MS Access MVP

 

[mart10]

Ha The trouble is I am writing this for a 'Muppet' so I am designing a macro for him. There is an initial delete querry followed by about 20 append queries. Everything is working perfect apart from need to generate the text as final part. The other option would be to save as CSV but access macros dont allow this. my final option would be to save as excel and then get the muppet to take off the header columns and save as CSV but Id really rather automate the whole thing!

 

[dhookom]

You can export to a csv format file with code like:

 DoCmd.TransferText acExportDelim, , strQuery, Me.txtFileName, Me.chkIncludeHeadings

strQuery is a query name, txtFileName is the destination file name, and chkIncludeHeadings is a boolean

Duane
Hook'D on Access
MS Access MVP

 

[assets]

Look at bookmarks

Never give up never give in.

There are no short cuts to anything worth doing