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 |
|
bob120579
Starting Member
2 Posts |
 Posted - 2009-05-28 : 12:04:10
|
| I have html report files (.html) that i need the actual data that resides in the report to store it in SQL to use as relational data. What is the best way that I can import this data from html into a sql table? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-28 : 12:16:13
|
No chance to get the data from source before it is going into the HTML file?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
bob120579
Starting Member
2 Posts |
Posted - 2009-05-28 : 12:23:25
|
| I'm afraid not. It is coming from another source and was a one time thing. We have a whole directory of these files. I just manually exported to excel and the formatting is clean, but I am looking to automate this in SSIS perhaps. |
|
|
|
|
|
|
Importing html files into SQL