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

Loading from web

P: n/a
I need to load Word documents from the web into OLE Object fields in
an MS Access database.

My DB table has two fields: A Text field which already holds the URL
of the Word document and an OLE Object field into which I want to load
that document.

I need to write a SQL Update query (or ADO code) to step through the
table and load all the documents. The code will need to handle
obvious errors (invalid or missing URL in the text field and/or
document not found errors from the web server).

Can anyone put me on the right track for how to do this?

Thanks

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


P: n/a
Sorry to comment on own post but forgot to say I am using Access 2002 and
backward compatibility to earlier versions isn't an issue.

Nigel

"Nigel Brooks" <ni***********@yahoo.co.uk> wrote in message
news:45*************************@posting.google.co m...
I need to load Word documents from the web into OLE Object fields in
an MS Access database.

My DB table has two fields: A Text field which already holds the URL
of the Word document and an OLE Object field into which I want to load
that document.

I need to write a SQL Update query (or ADO code) to step through the
table and load all the documents. The code will need to handle
obvious errors (invalid or missing URL in the text field and/or
document not found errors from the web server).

Can anyone put me on the right track for how to do this?

Thanks

Nigel

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.