Specification Name for Export (fixed-width)

[cbsm]

I have a query that I need to export in a fixed-width text file (.txt or .csv).
I tried to use the "transferText" command.
I see I need to specify a "Specification Name" and how no idea what this is (is this a file,a table or ???).
I looked for some time now but couldn't find any help.
My version of Access - 2000 is a bit buggy and I am unable to import/export by the wizzard.
I suppose I can create this (specification or shema.ini) manually - if only I new how it should look like etc...
Many thanks,

 

[ZmrAbdulla]

Specification Name is the type you transfer
==================================
From Help file..
AcTextTransferType can be one of these AcTextTransferType constants.
acExportDelim
acExportFixed
acExportHTML
acExportMerge
acImportDelim default
acImportFixed
acImportHTML
acLinkDelim
acLinkFixed
===========================
See more at topic "TransferText Method" in VBA help file.
acLinkHTML


________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[ZmrAbdulla]

Oh my bad..
Please ignore the answer..
I was just got confused myself.

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[psemianonymous]

The way you build a specification (import or export) is through the wizard. Sorry, time for you to get some service packs or otherwise reinstall Access/Windows.

It isn't worth the pain of figuring out how to manually build a specification.