Re: Exporting Data as text file
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Sat, 25 Nov 2006 07:01:07 -0500
To have the spaces replaced with zeroes, write a query that uses the Format
function on the numeric fields (not the Format property), and work with that
query rather than the table.
You should be able to use the TransferText method, but if that doesn't give
you a satisfactory result, you can always use the VBA Print # statement (in
conjunction with the Open and Close statements)
If you want to give your users the ability to choose where the file should
be put, consider using http://www.mvps.org/access/api/api0001.htm at "The
Access Web" rather than any other approach.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"wasimsono via AccessMonster.com" <u7424@uwe> wrote in message
news:69cea0b3c62e4@xxxxxx
Dear All
I want to export the data as text file but I want that only data should
trasfer and no spaces should transfer.Spaces in fileds ( e.g. the field
length is 8characte and the data is 456 then it should be as 00000456)
should
be replaces with zeros. This output file is required for COBOL processing.
Remember that it should all be done just like for a new user. The user Oly
select or click any button for 'Export' or 'Backup' and the all workd done
behind the scene.
Any help regarding this is highly appreciated.
Thanks in advance.
Wasim
--
Wasim Yasin
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200611/1
.
- References:
- Exporting Data as text file
- From: wasimsono via AccessMonster.com
- Exporting Data as text file
- Prev by Date: Exporting Data as text file
- Next by Date: Super Basic SQL LINKING question...
- Previous by thread: Exporting Data as text file
- Next by thread: Super Basic SQL LINKING question...
- Index(es):
Relevant Pages
|
