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 |
|
neoinbiz
Starting Member
2 Posts |
 Posted - 2004-05-25 : 15:21:02
|
| I am beginner level developer trying to import data from a file directory on my server to a SQL database. I have not created the database yet. I wanted to get some information on the best process to do this.I have information that is in multiple HTML pages that describes a product and diplays the image of the product. I would like to be able to access these via the web using a web based search tool to display the content and the images associated to them.Is this possible? Please let me know if there is more information needed for someone to provide an answer or point me in the correct direction. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-25 : 15:49:32
|
| So what are you importing? What format is the data in the file? CSV?Tara |
 |
|
|
neoinbiz
Starting Member
2 Posts |
Posted - 2004-05-25 : 15:51:50
|
It is .jpg and html file?quote:
Originally posted by tduggan
So what are you importing? What format is the data in the file? CSV?Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-25 : 15:57:53
|
| You want to put them in image columns in the database? You can not easily import data from html pages and jpg files should not be stored in the database. You should only store a pointer to the file on disk in the database.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-25 : 16:04:07
|
quote:
Originally posted by neoinbiz
It is .jpg and html file?quote:
Originally posted by tduggan
So what are you importing? What format is the data in the file? CSV?Tara
Are you asking us or telling us?Wonder if Yukon has enhanced support for images...Brett8-) |
|
|
|
|
|
|
Import data