Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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