Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suhailtholakkal
Starting Member
5 Posts |
 Posted - 2012-01-02 : 03:07:02
|
how can i import image,text from excel to sqlserver...the excel sheet may contained description about the images stored on excel..but how can i retrieve and insert it into sql server |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-02 : 03:17:41
|
| In what format is the image data stored in excel ?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-02 : 12:00:33
|
quote:
Originally posted by suhailtholakkal
how can i import image,text from excel to sqlserver...the excel sheet may contained description about the images stored on excel..but how can i retrieve and insert it into sql server
you mean inserting description or image themselves?Have a look at OPENROWSET BULK------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
suhailtholakkal
Starting Member
5 Posts |
Posted - 2012-01-03 : 00:42:26
|
| it may be .jpg or .gif or .png |
|
|
|
suhailtholakkal
Starting Member
5 Posts |
Posted - 2012-01-03 : 00:45:22
|
| I want to insert some images of camera and it's configuration description as a bulk from excel to sql server..or if it is not possible from excel...it can be from any other sources of csv? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-03 : 00:47:01
|
| Can you post on how exactly the image data is saved in the excel file ? Some screenshot or something of the excel file.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
how can i import image,text from excel to sqlserve