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 ...

Hi there.I have an XML file (generated from Microsoft Project). I would like to import this file into an Access table. I know I can do this from inside Access. The trick is being able to do it ...

A copy of Datawatchs $599 VorteXML Windows-based desktop text file-to-XML conversion tool is required to create the import templates VorteXML Server uses.