Export to Text File with newline delimiter

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

re: Export to Text File with newline delimiter

Jim,

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

Steve


"jim" <jim@blahblah.blahwrote in message
news:4_ednYVL_dhqs_zVnZ2dnUVZ8qPinZ2d@posted.metro net...

re: Export to Text File with newline delimiter

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:

re: Export to Text File with newline delimiter

Hi Jim,

Try the following:

Dim DB As DAO.Database
Dim Rst As Recordset
Set DB = CurrentDB()
Set Rst = DB.OpenRecordset("NameOfYourTable")
Open "C:\TESTFILE.Txt" 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.Txt" 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 rlaird@penn.com.

Steve

"jim" <jim@blahblah.blahwrote in message
news:fPidnT8VTODNn_nVnZ2dnUVZ8vCdnZ2d@posted.metro net...

re: Export to Text File with newline delimiter

"Mark" <notmy@email.comwrote in message
news:G_mdnfQjW6EvHPjVnZ2dnUVZ_uGdnZ2d@earthlink.co m...

re: Export to Text File with newline delimiter

"Mark" <notmy@email.com>
rlaird@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 **

re: Export to Text File with newline delimiter

On Fri, 27 Jun 2008 20:37:10 -0400, "John Marshall, MVP"
<lancucki@stonehenge.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.

re: Export to Text File with newline delimiter

"Mark" <notmy@email.comwrote
: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/

re: Export to Text File with newline delimiter

"Mark" <notmy@email.comschreef in bericht news:G_mdnfQjW6EvHPjVnZ2dnUVZ_uGdnZ2d@earthlink.co m...
--
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 ??
abuse@giganews.com (appropriate action will follow when there are enough complaints)
*********************************

Arno R

re: Export to Text File with newline delimiter

"Bob Quintal" <rquintal@sPAmpatico.caschreef in bericht news:Xns9ACADCB4C8E32BQuintal@66.175.223.2...
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 ??
abuse@giganews.com (appropriate action will follow when there are enough complaints)
*********************************

Arno R

re: Export to Text File with newline delimiter

"Mark" <notmy@email.comwrote in message
news:G_mdnfQjW6EvHPjVnZ2dnUVZ_uGdnZ2d@earthlink.co m...Still an arrogant pr1ck then Steve? Still think you have more talent than
all of the experts on here put together?

re: Export to Text File with newline delimiter

In article <48720de1$1_1@glkas0286.greenlnk.net>, here@there.com says...The quoted text does not imply that.

re: Export to Text File with newline delimiter

"Michael Gramelspacher" <gramelsp@psci.netwrote
It certainly does, Steve, but _your_ post tries to disguise that "Michael
Gramelspacher" is nothing more than another of Steve's sock-puppets posting
in support of itself. Buzz off, Michael/Mark/Steve/et al.

Larry Linson
Microsoft Office Access MVP

re: Export to Text File with newline delimiter

"Michael Gramelspacher" <gramelsp@psci.netwrote in message
news:MPG.22dbe30d770859f8989684@news.psci.net...You're right, how foolish of me. It doesn't imply it at all, it states it
as hard fact in plain text for all but a complete idiot to see, "Michael".

re: Export to Text File with newline delimiter

In article <48731506$1_1@glkas0286.greenlnk.net>, here@there.com says...It seems that people who do not agree with you are by definition idiots,
so I do not see any way to evade the charge. Not that it really matters
anyway though, does it, Keith.

re: Export to Text File with newline delimiter

"Michael Gramelspacher" <gramelsp@psci.netwrote in message
news:MPG.22dd2edea88110b0989688@news.psci.net...
If the cap fits ... but the "quoted text" is quite clear in its meaning (if
the collective might of all of the experience in this NG can't help then
come to good ol' Steve, the font of all knowledge).
You infer a charge? The only charge comes when Steve presents his bill to
his prey.
Not that what matters? No need to answer that actually, it doesn't matter
to me.