<div>
Why are you using ExportWithFormating if you don't want formatting?<br />
<br />
Use ExportDelimited instead.
</div>


Why are you using ExportWithFormating if you don't want formatting?

Use ExportDelimited instead.

<div>
You need to click the 'Show All Actions' button on the ribbon.
</div>


You need to click the 'Show All Actions' button on the ribbon.

<div>
Yes I found it but I can't use my query data to export.
</div>


Yes I found it but I can't use my query data to export.

<div>
Why not?<br />
You should be able to export any table or any Select query.
</div>


Why not?
You should be able to export any table or any Select query.

<div>
I am attaching an example of the access databse and I want to export the query1 data as a text file using a macro.<br />
<br />
Could you help in this?<br />
<br />
regards,<br />
<br />
Dallag
</div>


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

<div>
You need to attach the file.
</div>


Capture4.JPG

<div>
<div class="content wysiwyg-content">
Hi, I have created a macro to export an query data as a text.<br />
ExportWithFormating ¿ Text Files (*.txt)<br />
But still the text file is having lines between the rows and between the columns. How can I get rid of those lines?
</div>
</div>


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?

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.