Showing posts with label jpeg. Show all posts
Showing posts with label jpeg. Show all posts

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:
>

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.
>>