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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Import Excel with hyperlinks

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?
Go to Top of Page

dexeloper
Starting Member

3 Posts

Posted - 2014-11-04 : 17:28:03
nvarchar
I've tried sqlvariant and xml but don't see any difference
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -