Exporting Selected Columns Directly to Notepad

[deepgrewal22]

Currently my company is running Access 2003 and I am having issues exporting columns.

I would like to export only certain (not all) columns from a table into a Notepad file.

I have tried a number of techniques and don't want to export to Excel or some other program. I just want a direct export to Notepad.

Please advise. Thanx in advance!

 

[lespaul]

use a query that only contains the information you need as the source for the export. You should be able to export in a comma separated or tab delimited format.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[PHV]

Have a look at the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

Have a look at the DoCmd.Outputto method too.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[deepgrewal22]

How exactly do I go about accessing and editing:

DoCmd.TransferText
DoCmd.Outputto

Thanx for all of your replies!

Don't say the M word; you sound ignorant.