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/features/mssql/article.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...
> 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/features/mssql/article.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.
>>

No comments:

Post a Comment