CSV Recordset

I have managed to create a recordset from a csv file that live locally on my well 'ard drive - using the 'Microsoft Text Driver' and this works fine.

My question is can you read a csv that is not on the local drive

e.g. http://www.yourdomain.com/myfile.csv


????
:rolleyes:

Any Ideas??

You would have to use Winsock or a similar method to get the text file off the web and save it locally, then you could manipulate it.

If you have Excel installed, it will try to open it in the browser unless you do it the way JoshT said..