Is is possible to import an excel file with hyperlinks?
-
I have an excel file with five (5) columns. All the records in the second column are hyperlinked. When I tried importing the file to SQL Server, the hyperlinks are gone. I have spent almost 4 days googling to see if there is a way to do import this excel file with hyperlink either to a SQL Server DB or asp.net application but to no avail. Wondering if any of you experts has an idea how to do solve this problem? Many thanks in advance.
-
I have an excel file with five (5) columns. All the records in the second column are hyperlinked. When I tried importing the file to SQL Server, the hyperlinks are gone. I have spent almost 4 days googling to see if there is a way to do import this excel file with hyperlink either to a SQL Server DB or asp.net application but to no avail. Wondering if any of you experts has an idea how to do solve this problem? Many thanks in advance.
-
I have an excel file with five (5) columns. All the records in the second column are hyperlinked. When I tried importing the file to SQL Server, the hyperlinks are gone. I have spent almost 4 days googling to see if there is a way to do import this excel file with hyperlink either to a SQL Server DB or asp.net application but to no avail. Wondering if any of you experts has an idea how to do solve this problem? Many thanks in advance.
With no language, no code and very little information, the following might help, only as a shot in the dark - SSIS Extract links from Excel cells to load into SQL[^]
-
There is no code sir. I am just asking about importing excel with hyperlinks to sql server or asp.net applications.
-
Well you need to explain exactly how you are doing it and what actually happens when you do. We cannot be expected to guess what is going on.
LOL, The only way I have done import from excel to SQL Server is to use the SQL Server import utility. It always works. If you have imported files before to sql server, then nothing to guess there. The only issue this time around is that when I imported the file, the hyperlinks on the values for one of the columns was removed. Normally, this is not an issue for anyone who has encountered this type of problem. All I have asked for is whether anyone has had similar issue and if yes, how did they resolved it. Nothing really complicated about my question. If I Have a code and I am having problem making it work, I post the code and ask for help which I have done many times here.
-
LOL, The only way I have done import from excel to SQL Server is to use the SQL Server import utility. It always works. If you have imported files before to sql server, then nothing to guess there. The only issue this time around is that when I imported the file, the hyperlinks on the values for one of the columns was removed. Normally, this is not an issue for anyone who has encountered this type of problem. All I have asked for is whether anyone has had similar issue and if yes, how did they resolved it. Nothing really complicated about my question. If I Have a code and I am having problem making it work, I post the code and ask for help which I have done many times here.
samflex wrote:
The only way I have done import from excel to SQL Server is to use the SQL Server import utility.
Which you omitted to mention in your original question, leaving us in the dark as to how you were doing it.
samflex wrote:
nothing to guess there.
Actually everything to guess.
samflex wrote:
Nothing really complicated about my question.
That's a matter of opinion. Did you check Import data from Excel to SQL Server or Azure SQL Database - SQL Server | Microsoft Learn[^] ?
-
LOL, The only way I have done import from excel to SQL Server is to use the SQL Server import utility. It always works. If you have imported files before to sql server, then nothing to guess there. The only issue this time around is that when I imported the file, the hyperlinks on the values for one of the columns was removed. Normally, this is not an issue for anyone who has encountered this type of problem. All I have asked for is whether anyone has had similar issue and if yes, how did they resolved it. Nothing really complicated about my question. If I Have a code and I am having problem making it work, I post the code and ask for help which I have done many times here.
Sounds like someone who knows what the BCP Utility is because they use it regularly in their procedural code should be able to tell you why using various commandline options does what they're supposed to do ... or doesn't do what they're supposed to do. I think the direct object of that sentence is "using" ... so yeah, does/doesn't ...
-
I have an excel file with five (5) columns. All the records in the second column are hyperlinked. When I tried importing the file to SQL Server, the hyperlinks are gone. I have spent almost 4 days googling to see if there is a way to do import this excel file with hyperlink either to a SQL Server DB or asp.net application but to no avail. Wondering if any of you experts has an idea how to do solve this problem? Many thanks in advance.
Hyperlinks are a feature of Excel. They are not a data type. You can't store an Excel hyperlink in a database column. You can store the target address of a hyperlink, but not a hyperlink. Is it the target address of the hyperlink that you are looking to store? And what does show up in the SQL table when you import the file?
The difficult we do right away... ...the impossible takes slightly longer.
-
Hyperlinks are a feature of Excel. They are not a data type. You can't store an Excel hyperlink in a database column. You can store the target address of a hyperlink, but not a hyperlink. Is it the target address of the hyperlink that you are looking to store? And what does show up in the SQL table when you import the file?
The difficult we do right away... ...the impossible takes slightly longer.
Hi, I suppose that when you say target address of a hyperlink, you meant the location you are taking when you click on a hyperlink? Here is what we are trying to accomplish. We have directory on our server where several documents are stored. Then the excel file contains hyperlinks to those documents. For instance, one of the columns, called Director for example, the Director is hyperlinked Director. On the excel file, it is clearly hyperlinked and when clicked, takes you to the Files directory and Director file. There are over 600 of these records on excel. What we are trying to do is import the contents of the excel file to the database then use our .net app to display these records on our site so users can visit the site search for any title info, find it, cick the hyperlink to take him/her to the file on the server. So, after importing the file to the database, all you see now is the text Director. The hyperlink is stripped away.
