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 |
|
dexeloper
Starting Member
3 Posts |
 Posted - 2014-11-04 : 15:09:13
|
| I want to import an Excel spreadsheet into a SQL table. One of the Excel columns is hyperlink and importing loses the link address.Any ideas? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-04 : 16:08:14
|
| How is the corresponding column defined in SQL? |
 |
|
|
dexeloper
Starting Member
3 Posts |
Posted - 2014-11-04 : 17:28:03
|
| nvarcharI've tried sqlvariant and xml but don't see any difference |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-04 : 18:42:27
|
| What are you using to do the import? Also, what is the length of the nvarchar column? Finally, can you post a lie or two of sample data? |
|
|
|
dexeloper
Starting Member
3 Posts |
Posted - 2014-11-05 : 11:37:26
|
| Doing the import via Management Studio. I don't think this is going to get anywhere.Eventually went into the spreadsheet and extracted the link address to another column.Suspect SQLServer Import can't handle Excel hyperlinks. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-05 : 12:24:52
|
| SQL Server is blissfully ignorant of the contents of Excel columns. Its just data. Do you mean you used the Import wizard? That's just SSIS with a simple front end. It would be interesting to look at the package in BIDS and see what it generated. Could be a problem there somewhere. |
|
|
|
|
|
|
Import Excel with hyperlinks