Excel Convert Url Text To Clickable Hyperlink
Supposing you have multiple URLs in your worksheet, but they are not linked, and now you need to […]
excel
Create Table SQL Script in Excel
You have some data in Excel that you need to import into SQL Server. You don’t have a […]
Excel Combine Worksheet Data
The objective for this post is to learn how to combine (merge) more than one Excel worksheet file […]
SQL Server Linked to Excel
You can link Excel to a SQL Server database so that you can read data from SQL Server […]
SQL Server Export to Excel
https://www.microsoft.com/en-us/download/details.aspx?id=23734 Wizard From within SQL Server you can use the wizard to export a tables or tables (using […]
Import XML File to Excel Part 2
This blog post continues from the previous one called Import XML File to Excel. Now, assume we have […]
Import XML File to Excel
In this blog post we follow the instruction at the MSDN website’s article Creating an XML Mapping Schema […]
T-SQL Bulk Insert-Output of Text Files
At lot of times when working with databases you will find that you need to import a text […]
Embed Documents
You can embed PDFs in a WordPress blog and make it available for others to download as well. […]
Excel to SQL Server with Copy Paste
You can import a table of Excel data into a SQL Server database without having to re-type any […]