Friday, February 24, 2012

Bulk insert

Hi,
i'm trying to store some bitmap or jpeg files located on my harddrive into a
table of my datable which have an image type field.
while looking at different help files, it seems to be possible with bulk
insert ...
does anybody got a simple way to to such a job ?
best regards.Franck,
In version 2000, you will find a utility named textcopy.exe, installed on
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn". See if this helps.
Copy Text or Image into or out of SQL Server
http://www.databasejournal.com/feat...cle.php/1443521
AMB
"Franck Fouache" wrote:

> Hi,
> i'm trying to store some bitmap or jpeg files located on my harddrive into
a
> table of my datable which have an image type field.
> while looking at different help files, it seems to be possible with bulk
> insert ...
> does anybody got a simple way to to such a job ?
> best regards.
>
>|||Yes it helps ...
as i didn't know textcopy exists i thought bulk insert was the only way ...
thanks for your help Alejandro.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> a crit dans le
message de news: F8380DA0-0EF8-454E-B0FB-234CA7661816@.microsoft.com...[vbcol=seagreen]
> Franck,
> In version 2000, you will find a utility named textcopy.exe, installed on
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn". See if this helps.
> Copy Text or Image into or out of SQL Server
> http://www.databasejournal.com/feat...cle.php/1443521
>
> AMB
> "Franck Fouache" wrote:
>

No comments:

Post a Comment