When Excel will not convert a date to a date
While working with several CSV files, I found myself in a strange situation. I had merged the file contents into […]
Excel
Find numbers within a string in Excel
Learn how to use excel to extract numbers from strings.
Working with Seconds in Excel
I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
SQL Blogs
Importing Data into SQL Server – Using Excel Shortcuts
I’ll be the first to say, the switch from DTS to SSIS was painful. DTS would go through a lot