I am trying to copy a list of email addresses in Excel and paste them into SQL. I am using Navicat. I am able to paste the text, but I lose the hyperlink format. What can I do? Obviously, I new at this. Any help would be appreciated. Thanks...Gadfly_1943
Gadfly_1943
0
Newbie Poster
Recommended Answers
Jump to PostIs there any reason that u would need the hyperlink inside a database?
You could always just read the values from the database and then code in the links in whatever language u are using
All 2 Replies
Thirusha
20
Posting Whiz
Is there any reason that u would need the hyperlink inside a database?
You could always just read the values from the database and then code in the links in whatever language u are using
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
You get a hyperlink in Excel because Excel recognizes the email format. Navicat just treats it as text.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.