var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Accessing data in .txt file on the internet
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?