I'm trying to import weather data from a .txt file located on the internet into a table in Access 97 SR-2 using VBA. (http://www.cpc.ncep.noaa.gov/product...s/cfstwpws.txt)

I want to provide a form with a button that will update the local table from the internet.

I tried linking a table, but it seems that Access doesn't want to import or link a .txt file from the internet.

Is there a way to copy the txt file from the internet from VBA and then use TrasferText() to import the file? Is there a better way to do this?


Johan vLvT