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 a single CSV file. I then opened the file in Excel, only to find that the Date column had data that was a mix of YYYY-MM-DD and MM/DD/YYYY. There are several things that can cause...
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.
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 of implicit conversions so you didn’t have to worry or think about them. But SSIS was not as merciful. From different fields lengths to different encodings, SSIS wants you to be specific. Sometimes, it is...
