Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2012-04-04
10
Medium Priority
?
188 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 2000 total points
ID: 37816803
See example attached.
Capture4.JPG
0
 

Author Closing Comment

by:Mohammed Dallag
ID: 37818342
Thank you
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

730 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