• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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