469,282 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

How to create own tab delimited file

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
Nov 12 '05 #1
5 8914
"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)
Nov 12 '05 #2
"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)
Nov 12 '05 #3
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)
Nov 12 '05 #4
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)

Nov 12 '05 #5
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

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by monte | last post: by
1 post views Thread by The Bear | last post: by
5 posts views Thread by RyanL | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.