Solved

Access Macro   - Output Text to

Posted on 2007-04-02
2
1,071 Views
Last Modified: 2013-11-27
I need help creating a macro for Access 2000. I need to export to a text file from a query.
I created the macro using "Output To" and I need to use comma delimited file with the column headers. There are no prompts. Can anyone help?
Thanks
0
Comment
Question by:mancoi
[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
2 Comments
 
LVL 9

Accepted Solution

by:
Volibrawl earned 500 total points
ID: 18837601
From the Menu, Pick Insert Macro

For action Choose Transfer Text, Export Delimited
Table name = Query name
file= c:\myquery.txt
has field names = yes.

name the macro, then run it.



0
 

Author Comment

by:mancoi
ID: 18838767
Perfect thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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 …

756 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