Making an ASCII file

[quinto via AccessMonster.com]

I try to search here but I could not find basic instruction or guidelines on
how to export a table to ASCII file with set field.

I have all of the required fields formatted as needed.
1-10 Division number ex. 101
11-40 First Name
41-70 Last Name
71-100 Middle Name
101-130 Route Name
131-160 Pull Out Time
161-190 Pull In Time
191-220 Employee ID
221-250 BadgeNumber
251-280 Schedule Date YYYYMMDD
Can anyone give me some directions, I am using 2007

Thanks

Quinto

 

[Scott Shearer]

I assume that you want to do the export programatically rather than by using
the export wizard. Am I correct?

 

[quinto via AccessMonster.com]

Yes, it would be once a day thing

Thanks

Quinto

I assume that you want to do the export programatically rather than by using
the export wizard. Am I correct?

I try to search here but I could not find basic instruction or guidelines on
how to export a table to ASCII file with set field.

[quoted text clipped - 15 lines]

Quinto

 

[Daniel Pineault]

I do not believe that is what Scott was refering to when he asked about
programatically. I would think he was asking if you wanted to used VBA to
perform the action.

Manual Method
You can do this manually, select the Table or Query and then select the
Export command from the File menu. When the Export File Dialog pops-up you
can then change the Save As Type to txt and follow the remainder of the
on-screen instructions.

VBA Method
If on the other hand you wish to perform the export using VBA, there are a
couple of different approaches that can be used. I would suggest you look
into either

TransferText Method
OutputTo Method

in the VBE help. If you need further assistance, simply reply to this post
with more details on how we can help.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

Yes, it would be once a day thing

Thanks

Quinto

I assume that you want to do the export programatically rather than by using
the export wizard. Am I correct?

I try to search here but I could not find basic instruction or guidelines on
how to export a table to ASCII file with set field.

[quoted text clipped - 15 lines]

Quinto

 

[quinto via AccessMonster.com]

Since the users will have a problem using the wizard I would like to
accomplish this with a command button but my knowledge of VBA is none, I
tried to search but I did not come up with anything that I understood or able
to use.
I will keep trying and thanks for any help you can provide me.

Quinto

I do not believe that is what Scott was refering to when he asked about
programatically. I would think he was asking if you wanted to used VBA to
perform the action.

Manual Method
You can do this manually, select the Table or Query and then select the
Export command from the File menu. When the Export File Dialog pops-up you
can then change the Save As Type to txt and follow the remainder of the
on-screen instructions.

VBA Method
If on the other hand you wish to perform the export using VBA, there are a
couple of different approaches that can be used. I would suggest you look
into either

TransferText Method
OutputTo Method

in the VBE help. If you need further assistance, simply reply to this post
with more details on how we can help.

Yes, it would be once a day thing

[quoted text clipped - 10 lines]