One way to turn a CSV file into a Microsoft Excel spreadsheet is to open the document in Excel, but with this method you won't see the text-import wizard that allows you to specify how Excel ...

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

For instance, Excel will strip leading zeros from numbers and dates because they are not mathematically significant. You can keep the leading zeros in CSV files by using Excel's Text Import Wizard.

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.