Bulk insert to sql database

Hi

I want to perform the bulk insertion to the SQL database, I access through
ODBC connection. I want the guidance regarding the same.

Rujuta

William
Thu Apr 21 08:42:49 CDT 2005

"Rujuta Gandhi" <rujuta_g2000@yahoo.com> wrote in message
news:OajZlJlRFHA.3928@TK2MSFTNGP09.phx.gbl...
> I want to perform the bulk insertion to the SQL database, I access through
> ODBC connection. I want the guidance regarding the same.

If no one responds here, try posting in

microsoft.public.data.odbc

Regards,
Will

Arnie
Thu Apr 21 10:03:19 CDT 2005

"Rujuta Gandhi" <rujuta_g2000@yahoo.com> wrote in message
news:OajZlJlRFHA.3928@TK2MSFTNGP09.phx.gbl...
> Hi
>
> I want to perform the bulk insertion to the SQL database, I
> access through
> ODBC connection. I want the guidance regarding the same.
>
> Rujuta

If you mean SQL Server, it has a bulk insert API. Check the
documentation.

- Arnie

Rujuta
Fri Apr 22 01:46:23 CDT 2005

Hi Arnie

I know that option, but this is used for insertion from the file.
I want to insert the number of rows at a time from the arrays in my vc++
program. I mean as if i have the collection of rows to be inserted at a
time.
Thanks
Ruju

"Arnie" <none> wrote in message
news:uJlF0NoRFHA.3560@TK2MSFTNGP14.phx.gbl...
> "Rujuta Gandhi" <rujuta_g2000@yahoo.com> wrote in message
> news:OajZlJlRFHA.3928@TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > I want to perform the bulk insertion to the SQL database, I
> > access through
> > ODBC connection. I want the guidance regarding the same.
> >
> > Rujuta
>
> If you mean SQL Server, it has a bulk insert API. Check the
> documentation.
>
> - Arnie
>
>

onega
Fri Apr 22 03:05:49 CDT 2005

Rujuta Gandhi wrote:
> Hi Arnie
>
> I know that option, but this is used for insertion from the file.
> I want to insert the number of rows at a time from the arrays in my vc++
> program. I mean as if i have the collection of rows to be inserted at a
> time.
> Thanks
> Ruju
>
> "Arnie" <none> wrote in message
> news:uJlF0NoRFHA.3560@TK2MSFTNGP14.phx.gbl...
>
>>"Rujuta Gandhi" <rujuta_g2000@yahoo.com> wrote in message
>>news:OajZlJlRFHA.3928@TK2MSFTNGP09.phx.gbl...
>>
>>>Hi
>>>
>>>I want to perform the bulk insertion to the SQL database, I
>>>access through
>>>ODBC connection. I want the guidance regarding the same.
>>>
>>>Rujuta
>>
>>If you mean SQL Server, it has a bulk insert API. Check the
>>documentation.
>>
>>- Arnie
>>
>>
>
>
>
Maybe you can build a long sql
insert into table1 values(...);insert into table1 values(...);...

Severian
Fri Apr 22 10:38:03 CDT 2005

On Thu, 21 Apr 2005 14:39:20 +0530, "Rujuta Gandhi"
<rujuta_g2000@yahoo.com> wrote:

>Hi
>
>I want to perform the bulk insertion to the SQL database, I access through
>ODBC connection. I want the guidance regarding the same.

Did you investigate the ODCB extension bcp_ operations for SQL Server?

In 2003 MSDN library:

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/odbcsql/od_odbc_bcp_5183.htm

Online:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_bcp_5183.asp
In case of wrap: http://tinyurl.com/aou2u


--
Phillip Crews aka Severian
Microsoft MVP, Windows SDK
Posting email address is real, but please post replies on the newsgroup.

Rujuta
Sat Apr 23 04:36:20 CDT 2005

Hi
Thanks.
I have got the solution from that site.
Ruju
"Severian [MVP]" <severian@chlamydia-is-not-a-flower.com> wrote in message
news:5c6i61t0pg4q1tkk8b9jq4m1ajtr5e92gu@4ax.com...
> On Thu, 21 Apr 2005 14:39:20 +0530, "Rujuta Gandhi"
> <rujuta_g2000@yahoo.com> wrote:
>
> >Hi
> >
> >I want to perform the bulk insertion to the SQL database, I access
through
> >ODBC connection. I want the guidance regarding the same.
>
> Did you investigate the ODCB extension bcp_ operations for SQL Server?
>
> In 2003 MSDN library:
>
>
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/odbcsql/od_odbc_bcp_5183.htm
>
> Online:
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_
odbc_bcp_5183.asp
> In case of wrap: http://tinyurl.com/aou2u
>
>
> --
> Phillip Crews aka Severian
> Microsoft MVP, Windows SDK
> Posting email address is real, but please post replies on the newsgroup.