Re: What's the best way to open a recordset for insert only?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 8 Apr 2008 11:56:49 -0400
Spencer wrote:
So I found myself having to import a boatload of multimillion-lineReally? Why wouldn't you import them into a staging table and then use
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.
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.
.
- Follow-Ups:
- References:
- What's the best way to open a recordset for insert only?
- From: Spencer
- What's the best way to open a recordset for insert only?
- Prev by Date: Re: vb6/ADO 2.8/ DB2
- Next by Date: Re: What's the best way to open a recordset for insert only?
- Previous by thread: Re: What's the best way to open a recordset for insert only?
- Next by thread: Re: What's the best way to open a recordset for insert only?
- Index(es):
Relevant Pages
|
