Importing File from HTTP

[JBats]

I will create a procedure in my VB6 project that will import (copy) a text file from our website and store it in my local machine. The data in this text file will now be transferred to my Sybase SQL Database.

How can I do this? Is there an existing discussions in this forum that can be a used as my reference?

Any help would be highly appreciated.

Thanks in advance



JBats
Good is not better if not than best...

 

[Sheco]

You can use the INet control to pull the file, or just open a socket and write the raw http request yourself.

Then you can parse it with either the FSO or the native file functions like Open, Get/Put, and Close.

Then insert it into you database with ADO.