pull information from web with Access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to pull information from the web from inside of Access with a query.
I currently have an Excel workbook that is getting the information and I have
the Excel workbook linked into Access. I would like to skip the Excel step if
possible.

Any suggestions would be greatly appreciated.

Thanks,

Bruce
 
The simple thing to do is use automation from Access to open an instance of
Excel, do the process in Excel to get your info and save it in Access. Look
up automation in the Help file.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.
 
Bruce

Are you saying that you want Access to link to a website to get data?

In what file format does the data exist on the web (e.g., in a SQL-Server
table)? Can you create an ODBC link to the data?
 
Back
Top