Solved

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

Posted on 2012-04-04
10
183 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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
 

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 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