2. ASPRunnerPro General questions
  3. copy files from a URL to an access database
This topic is locked

copy files from a URL to an access database

 		5/13/2005 10:27:22 AM
ASPRunnerPro General questions
author

Hi all,
Can anyone tell me how to store files in an access database (which contains a row whose columns are filename, filesize, content-type, file description, and filedata (which is an OLE field)).
In details, I want to copy a file (of any type) from a given URL and store in the access database, as mentioned above.
If possible, can you also describe ways to let the user download the files and provide sample codes for all the above asp files? (or at least a link that can be used to download the codes)
Thanks
Sergey Kornilov admin 5/16/2005

Hi,
you can't do it using ASPRunner.
501207 5/16/2005

Oh, just realised it .... Then, is there any way to do that without using ASPRunner (i.e by writing pure ASP (VbScript) code) ?
Sergey Kornilov admin 5/18/2005

Hi,
you can use this code snippet:

set oHTTP = Server.CreateObject("Msxml2.XMLHTTP.3.0")

oHTTP.open "GET", strURL, False

oHTTP.send

strWebPage = oHTTP.responseText