Good old FTP and flat file import will do the trick ... download in Windows followed by a CSV insert into MS SQL Server. Step one is to fetch the latest data from another server via FTP.

Microsoft's SQL ... data with suppliers, field offices and other business partners. You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server ...

I have a daily generated csv file that I'm going to have its contents inserted into tables in our SQL Server database. I can open the csv as a recordset in ADO, but I'm not sure how I open a ...