Solved

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

Posted on 2012-04-04
10
181 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:dallagmm
  • 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:dallagmm
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
 

Author Comment

by:dallagmm
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:dallagmm
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:dallagmm
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:dallagmm
ID: 37818342
Thank you
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

705 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now