Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime. As much as it can be a pain, a lot of projects still require that you import data ...

FTP Download Step one is to fetch the latest data from another server via FTP. In Windows you can accomplish this using a script to send ftp commands.

Though primarily targeted at IT pros, the scripts are helpful for developers, too, as pointed out recently by Jialiang Ge, who works at a sister project called the All-In-One Code Framework.

Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.