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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-24 : 09:39:25
|
| sanal writes "Hi,I have a problem.My task is to import data from excel sheet to SQL server database using DTS package.This data is then used as content in html pages. The real problem is that, one of the columns in the excel sheet has formatted text like bold, italics, bullets etc. I have to preserve this format while uploading to the database. We can do this simply by adding the html tags like and to the excel column and upload the same to the column with data type ‘text’ in the Sql server table. But strictly, I want to avoid adding html tags in excel but simply the formatted text as it should look. I also strictly want to use the excel sheet (no other datasource). Is there any way to do this? Please respond immediately as this is very urgent.Regards,Sanal" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-24 : 09:41:33
|
| If this is really that important, I'd suggest avoiding the database import entirely. Excel can save to an HTML file that will preserve formatting. It will be much more difficult if not impossible to preserve formatting if you import to SQL Server. |
 |
|
|
|
|
|
Preserve formatting during Excel import