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.

I want to open an XML file and input it's contents into an Access 2003 database. I know I can import XML files using Access, but I don't want to do this through the GUI one at a time. I want to ...