By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,576 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

How to create own tab delimited file

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
"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

P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
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.