Solved

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

Posted on 2012-04-04
10
186 Views
Last Modified: 2012-04-06
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
Comment
Question by:Mohammed Dallag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 37809795
Why are you using ExportWithFormating if you don't want formatting?

Use ExportDelimited instead.
0
 

Author Comment

by:Mohammed Dallag
ID: 37809908
No ExportDelimited in the list option. Please see the snapshot attached.

Regards,

Dallag
No-ExportDelimited.jpg
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37809967
You need to click the 'Show All Actions' button on the ribbon.
0
Industry Leaders: 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!

 

Author Comment

by:Mohammed Dallag
ID: 37810215
Yes I found it but I can't use my query data to export.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37810644
Why not?
You should be able to export any table or any Select query.
0
 

Author Comment

by:Mohammed Dallag
ID: 37816101
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
 
LVL 77

Expert Comment

by:peter57r
ID: 37816223
You need to attach the file.
0
 

Author Comment

by:Mohammed Dallag
ID: 37816693
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
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 37816803
See example attached.
Capture4.JPG
0
 

Author Closing Comment

by:Mohammed Dallag
ID: 37818342
Thank you
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

623 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