Re: What's the best way to open a recordset for insert only?

Spencer wrote:
So I found myself having to import a boatload of multimillion-line
text files into SQL Server. Because of idiosyncrasies in the data,
BULK INSERT and DTS proved impracticable. Which meant writing a
standalone program to do it.

Really? Why wouldn't you import them into a staging table and then use
t-sql to process them? I think you will find ADO choking on this amount
of data.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Whats the best way to open a recordset for insert only?
    ... Because of idiosyncrasies in the data, ... BULK INSERT and DTS proved impracticable. ... Which meant writing a ... standalone program to do it. ...
    (microsoft.public.data.ado)
  • Re: Giuliani: ENEMY of Freedom and Fireworks!
    ... At other times it is done just to keep the newsgroup alive ... Mike, although I once did professional writing (Wall Street analytical ...
    (rec.pyrotechnics)
  • Re: Whos Who in MW
    ... that we all might take part in creating a newsgroup where the ... someone's opinions or their attempts at writing in this newsgroup ... I've decided to try and avoid the crap. ... Josh? ...
    (misc.writing)
  • Re: Thanks for the help
    ... *some questions about formatting and some questions about the writing. ... first, engaging with _the process of writing_, one of the core topics ... core mission of the newsgroup. ... The rules are there to keep the newsgroup a functioning conversation, ...
    (rec.arts.sf.composition)
  • Re: Experimental collaboration
    ... Creative Writing who has sent anything in here. ... It is highly unlikely that one would expect to find quality criticism in a public newsgroup. ... He could be the tea lady at my local primary school, your next door neighbour, or Dan Brown wondering what people are saying about him. ... While some people are happy to contribute pieces of writing, others only wish to disrupt this process. ...
    (uk.culture.arts.writing)