Alter .txt file from Access VBA

[ossse]

When a table is filtered, I use the OutputTo command to save it as a .txt file. This works great, however the field names show up at the top of the text file, and the tab spacing is not how I would like it.

Is there a way to get rid of the first line in the text file (field names)? Is there a way to change the tab spacing? I would like to do everthing from a Access module.

I have no idea where to start, so I'm just looking for a point in the right direction right now...

Thanks in advance

 

[Remou]

Have you considered TransferText?

 

[ossse]

I have tried TransferText, but it includes all records, whereas I would just like the filtered records.

 

[CautionMP]

7489588,
Create a query with the appropriate filters and use that as the data source for [tt]TramsferText[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)