Download the CSV file to your harddrive and link to it. This is your initial
reference to the file. You can now daily delete the CSV file, download a new
CSV file and save it to the SAME location. You will not have to do anything
about the link.
Create an append query based on the linked table from The CSV file and
append to the desired table.
To recap, when there is a new CSV file on the webpage, delete your existing
CSV file, download the new CSV file to the SAME location and run your append
query.
If you need help automating this, I can help you for a reasonable fee.
Contact me at my email address below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Alex" <ll***@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi,
Everyday, I download data from a webpage and manually input data into
my MS Access database. I am thinking of automate the routine by a VB
script.
The webpage I am visiting will return a csv file, with only one row.
In this row, there are several columns of data. I would like to add
these data as a NEW row in my data base.
I guess this is pretty easy to do for experienced VB programmer. But I
am new to VB. Could you give me a template or a tutorial webpage?
Thank you very much.
Alex