How to create own tab delimited file

[Danny]

How do you create your own tab delimited ms access file.
What is the TAB character and what is the NEWLINE character,
also how to write to a text file

Thanks in advance

[Lyle Fairfield]

"Danny" <da********@hotmail.com> wrote in news:32JWb.8522$I67.3108570
@news4.srv.hcvlny.cv.net:

How do you create your own tab delimited ms access file.
What is the TAB character and what is the NEWLINE character,
also how to write to a text file

Perhaps, learning to use the help file wuld be a great plane for you.

Assuming a current version of access, open the VB Window with <ALT><F
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Lyle Fairfield]

"Danny" <da********@hotmail.com> wrote in news:32JWb.8522$I67.3108570
@news4.srv.hcvlny.cv.net:

How do you create your own tab delimited ms access file.
What is the TAB character and what is the NEWLINE character,
also how to write to a text file

Thanks in advance

Assuming a not too ancient version of Access open the VB window with <ALT>
<F11>. Click Help.
Type something like
"how to write to a file"
into the Answer Wizard dialog.
You will find references to all you need to know, and you can pick what is
suitable for you.

Of course, if you are exporting data, you may want to look at the
"TransferText" method, which does most of the dirty work for you.

I recommend using VBNewline and VBTab for new line and tab characters.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Lyle Fairfield]

Lyle Fairfield <Mi************@Invalid.Com> wrote in
news:Xn*******************@130.133.1.17:

"Danny" <da********@hotmail.com> wrote in news:32JWb.8522$I67.3108570
@news4.srv.hcvlny.cv.net:

How do you create your own tab delimited ms access file.
What is the TAB character and what is the NEWLINE character,
also how to write to a text file

Perhaps, learning to use the help file wuld be a great plane for you.

Assuming a current version of access, open the VB Window with <ALT><F

Hmmm ... perhaps one should be careful with the <ALT> and Function keys when
writing a reply with XNews as it seems there is some combination that posts
the message and closes the window without warning.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Danny]

THank you

I have to put some header info into this file, so I cant just export, but do
you know if there is an easy way to combine two text files in access? This
way I can do the export, and just append this file to the header text file.

Thanks in advance

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn*******************@130.133.1.17...

"Danny" <da********@hotmail.com> wrote in news:32JWb.8522$I67.3108570
@news4.srv.hcvlny.cv.net:

How do you create your own tab delimited ms access file.
What is the TAB character and what is the NEWLINE character,
also how to write to a text file

Thanks in advance

Assuming a not too ancient version of Access open the VB window with <ALT>
<F11>. Click Help.
Type something like
"how to write to a file"
into the Answer Wizard dialog.
You will find references to all you need to know, and you can pick what is
suitable for you.

Of course, if you are exporting data, you may want to look at the
"TransferText" method, which does most of the dirty work for you.

I recommend using VBNewline and VBTab for new line and tab characters.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Bas Cost Budde]

Danny wrote:

THank you

I have to put some header info into this file, so I cant just export, but do
you know if there is an easy way to combine two text files in access? This
way I can do the export, and just append this file to the header text file.

You could create a batch file that does copy file1.txt+file2.txt
result.txt and call that from Shell()
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl