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.

Click the "Macro Name" drop-down menu and select the macro you created. Click "OK" to run the macro. Excel imports the spreadsheet data into the table.

How to Populate a Website From an Excel Database. Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a spreadsheet application, but an Excel file can also ...

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