web database reporting
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Web Database Reporting

Web Database Reporting

resolvedResolved · High Priority · Version 2003

replyReply Fri 24 Apr 2009, 16:11Delegate Arabella said...

Arabella has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Web Database Reporting

The best way to pull information from a web based database into Access?

For upcoming training course dates see: Pricing & availability

replyReply Mon 27 Apr 2009, 13:33Trainer Simon said...

RE: Web Database Reporting

Hi Arabella,

Thank you for your question.

Use the File Get External data command and then Import Data.

If you have the database on SharePoint, then there is a specific option which allows you to put the URL address in.

Alternatively try the HTML option.

I hope this answers your question.

Regards

Simon

Sun 3 May 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard