Re: Bulk Insert - Help
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Mon, 17 Oct 2005 21:10:46 +0400
Look at BULK INSERT in BOL - you will to execute this command with, for
example, TADOCommand.
Or, if you generate data in program, try OLEDB Direct
(http://www.oledbdirect.com) - it supports fast load interface, the same
mechanism as bulk copy uses. Look Examples\SQL Server\1 000 000 rows as
example on how to insert 1 million rows into simple table in MS SQL Server
in ~10 sec.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Mark Moss" <markmoss@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4351a9d1$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Ladies / Gentlemen
>
>
> I need to do a 'Bulk Insert' into a Microsoft SQL Server from
> within
> a
> Delphi 6 program. Can someone provide an example on what needs to be
> done.
>
>
> Thanks
>
>
> Mark Moss
>
>
>
.
- References:
- Bulk Insert - Help
- From: Mark Moss
- Bulk Insert - Help
- Prev by Date: Re: ADOConnection fail after a while in TThread
- Next by Date: Re: ADOConnection fail after a while in TThread
- Previous by thread: Re: Bulk Insert - Help
- Next by thread: [Q] Dynamically built Locate calls on compound fields don't work for some reason
- Index(es):
Relevant Pages
|
