Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to connect to an online access db via excel

Status
Not open for further replies.
Mar 17, 2005
147
US
I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be?

thanks for any help with this.

Steve
 

Steve,

Take a look at menu item

Data/get External data/New Web Query...

Skip,

[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue]
 
Thanks Skip I tried that but when I try to map to the database throught the url I get access forbidden read access turned off.

Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top