Export to Text File with newline delimiter

[jim]

Hi All,

I need to export a query to a text file but i need each field delimited
by a new line. Cant seem to find a way to do it.

any ideas..

thanks

jim

[Mark]

Jim,

Could you clarify what you mean by "each field delimited by a new line".
Does the query return multiple records?

Steve
"jim" <ji*@blahblah.b lahwrote in message
news:4_******** *************** *******@posted. metronet...

Hi All,

I need to export a query to a text file but i need each field delimited by
a new line. Cant seem to find a way to do it.

any ideas..

thanks

jim

[jim]

Hi Steve,

Thanks for the reply... i have a table with username and email addresses
and i wish to output it as follows:

username1
email1

username2
email2

username3
email3

rather than:
username1, email1
username2, email2
username3, email3
cant seem to find a way to do it.... any ideas appreciated..

cheers

jim
Mark wrote:

Jim,

Could you clarify what you mean by "each field delimited by a new line".
Does the query return multiple records?

Steve
"jim" <ji*@blahblah.b lahwrote in message
news:4_******** *************** *******@posted. metronet...

>Hi All,

I need to export a query to a text file but i need each field delimited by
a new line. Cant seem to find a way to do it.

any ideas..

thanks

jim

[Mark]

Hi Jim,

Try the following:

Dim DB As DAO.Database
Dim Rst As Recordset
Set DB = CurrentDB()
Set Rst = DB.OpenRecordse t("NameOfYourTa ble")
Open "C:\TESTFILE.Tx t" For Output As #1
Do Until Rst.EOF
Print #1, Rst!UserName
Print #1, Rst!Email
Print #1, ""
Rst.MoveNext
Loop
Close #1
Set DB = Nothing
Rst.Close
Set Rst = Nothing

Notes ....

1. In the line Open "C:\TESTFILE.Tx t" For Output As #1, Change
C:\TESTFILE.Txt to wherever you wantto store your text data.
2. In the two lines, Print #1, Rst!UserName and Print #1, Rst!Email, be
sure to use the actual field names in your table

I provide users a resource for help with Access, Excel and Word
applications. My fees ar very reasonable. If you ever need help beyond what
a newsgroup can provide, please contact me at rl****@penn.com.

Steve

"jim" <ji*@blahblah.b lahwrote in message
news:fP******** *************** *******@posted. metronet...

Hi Steve,

Thanks for the reply... i have a table with username and email addresses
and i wish to output it as follows:

username1
email1

username2
email2

username3
email3

rather than:
username1, email1
username2, email2
username3, email3
cant seem to find a way to do it.... any ideas appreciated..

cheers

jim
Mark wrote:

>Jim,

Could you clarify what you mean by "each field delimited by a new line".
Does the query return multiple records?

Steve
"jim" <ji*@blahblah.b lahwrote in message
news:4_******* *************** ********@posted .metronet...

>>Hi All,

I need to export a query to a text file but i need each field delimited
by a new line. Cant seem to find a way to do it.

any ideas..

thanks

jim

[John Marshall, MVP]

"Mark" <no***@email.co mwrote in message
news:G_******** *************** *******@earthli nk.com...

I provide users a resource for help with Access, Excel and Word
applications. My fees ar very reasonable. If you ever need help beyond
what a newsgroup can provide, please contact me at rl****@penn.com.

Steve

[Bob Quintal]

"Mark" <no***@email.co m>
rl****@penn.com.
Steve

What's worse is that he's showing his multiple personalities.

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

[Tom van Stiphout]

On Fri, 27 Jun 2008 20:37:10 -0400, "John Marshall, MVP"
<la******@stone henge.cawrote:

Per the newsgroup charter posted here:
http://www.mvps.org/access/netiquette.htm
it is not.
A certain Steve can't be bothered with that. That's why we shun him.

-Tom.

>"Mark" <no***@email.co mwrote in message
news:G_******* *************** ********@earthl ink.com...

>I provide users a resource for help with Access, Excel and Word
applications . My fees ar very reasonable. If you ever need help beyond
what a newsgroup can provide, please contact me at rl****@penn.com.

Steve

[Tony Toews [MVP]]

"Mark" <no***@email.co mwrote
:

>I provide users a resource for help with Access, Excel and Word
applications . My fees ar very reasonable. If you ever need help beyond what
a newsgroup can provide, please contact me at rl****@penn.com.

Steve

Soliciting for customers here too. Shame on you.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[StopThisAdvertising]

"Mark" <no***@email.co mschreef in bericht news:G_******** *************** *******@earthli nk.com...

Hi Jim,

I provide users a resource for help with Access, Excel and Word
applications. My fees ar very reasonable. If you ever need help beyond what
a newsgroup can provide, please contact me at rl****@penn.com.

Steve

--
ARRRGGGHHHHHHHH !!!!!!!!
--
http://home.tiscali.nl/arracom/whoissteve.html
(Earthlink kicked him out ?? SuperNews also ?? ==updated 'abuse-reporting')
Until now 5750+ pageloads, 3600+ first-time visitors (these figures are *real* and rapidly increasing)

*************** *************** ***
If anyone wants to help us getting rid of Steve (at least for a while) again ??
ab***@giganews. com (appropriate action will follow when there are enough complaints)
*************** *************** ***

Arno R

[Arno R]

"Bob Quintal" <rq******@sPAmp atico.caschreef in bericht news:Xn******** **************@ 66.175.223.2...

"Mark" <no***@email.co m
rl****@penn.com.
Steve

What's worse is that he's showing his multiple personalities.

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

He is showing his new ISP also: GigaNews.

http://home.tiscali.nl/arracom/whoissteve.html
(Earthlink kicked him out ?? SuperNews also ?? ==updated 'abuse-reporting')

*************** *************** ***
If anyone wants to help us getting rid of Steve (at least for a while) again ??
ab***@giganews. com (appropriate action will follow when there are enough complaints)
*************** *************** ***

Arno R