Solved

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

Posted on 2012-04-04
10
185 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

739 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