Hi,

I am trying to create a bat file which downloads two SPECIFIC FILES from a given url, the website is authenticated (via log in page) and the information is needed to be placed on the desktop once downloaded.

At the moment, I am only familiar with the use of FTP to download files via a bat file. The process does not work for http websites.

The website has a log in page, which then goes to a page where links are available. Then two specfic links are required to be downloaded from that page.


Any help on how to go about creating the bat file would be most appreciated!!!You can probably use wget.exe that can be downloaded from http://unxutils.sourceforge.net/

The SYNTAX of the batch file to use this COMMAND is going to depend on the METHOD of authentication and the files you need to download. Can you give us any more information?The files are located here:

http://stats.at-phm.co.uk/sss/app and I need to log into here to access the page with links

and I am downloading two .tab files at the following location:

http://stats.at-phm.co.uk/sss/text/39x7775fw1/2b160206-alt.tab

http://stats.at-phm.co.uk/sss/text/39x7775fw1/3c160206-alt.tab


The process needs to be automated by a bat file since I need to put the data into a file/table in SQL Server 2000 (the data is transformed within SQL Server into a format of what is required). At the moment I have to manually download the files and manually put in the data, but this process needs to be done more efficiently through automation. Im just totally stuck on this point at the moment.


Any help would be great. If you require any further information, please don't hesitate to ask.