By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,965 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,965 IT Pros & Developers. It's quick & easy.

MS Access DB auto update by VB (data download from web)

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.