Insert while looping

[Dave Karmens]

I'm running a query from a text file to return data that I will then use
to insert into SQL - could someone give an example as to how to insert
that data after it's read? or during the read?

[Bob Barrows]

Dave Karmens wrote:

> I'm running a query from a text file to return data that I will then
> use to insert into SQL - could someone give an example as to how to
> insert that data after it's read? or during the read?

You're talking about SQL Server? it sounds like a job for a BULK INSERT
query. Look it up in Books Online (BOL).

Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Ray at]

do while not oStream.AtEndOfStream
oADO.Execute "INSERT INTO YOURTABLE (YOURCOLUMN) VALUES ('" &
oStream.ReadLine & "')"
Loop

Ray at work


"Dave Karmens" <spam_just1coder@yahoo.ca> wrote in message
news:OXMSPC6$DHA.2056@TK2MSFTNGP11.phx.gbl...

> I'm running a query from a text file to return data that I will then use
> to insert into SQL - could someone give an example as to how to insert
> that data after it's read? or during the read?

[Bullschmidt]

Or perhaps within your loop have objRS.AddNew and then set each field...

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!