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

How can I export the data from an access query without format?

Hi, I have created a macro to export an query data as a text.
ExportWithFormating ¿ Text Files (*.txt)
But still the text file is having lines between the rows and between the columns. How can I get rid of those lines?
Regards,
Dallag
0
Mohammed Dallag
Asked:
Mohammed Dallag
  • 5
  • 5
1 Solution
 
peter57rCommented:
Why are you using ExportWithFormating if you don't want formatting?

Use ExportDelimited instead.
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
No ExportDelimited in the list option. Please see the snapshot attached.

Regards,

Dallag
No-ExportDelimited.jpg
0
 
peter57rCommented:
You need to click the 'Show All Actions' button on the ribbon.
0
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.

 
Mohammed DallagPetroleum ConsultantAuthor Commented:
Yes I found it but I can't use my query data to export.
0
 
peter57rCommented:
Why not?
You should be able to export any table or any Select query.
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
I am attaching an example of the access databse and I want to export the query1 data as a text file using a macro.

Could you help in this?

regards,

Dallag
0
 
peter57rCommented:
You need to attach the file.
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
I am attaching an example of the access databse and I want to export the query1 data as a text file using a macro.

Could you help in this?

regards,

Dallag
test1.accdb
0
 
peter57rCommented:
See example attached.
Capture4.JPG
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
Thank you
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.

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