navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Excel Data

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Excel Data
Page: [1]
 
chadb

 

Posts: 487
From: Kansas
Status: offline

 
Excel Data - 11/27/2007 11:35:09   
I have an excel spreadsheet that I would like to have a "live" link to on my intranet site. I just need 2 cells, and would like the page to update automatically if these cells are changed. Is an odbc driver the best way? And if so, I am getting the following error when trying to verify the database connection:

[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

Or is there a better way to do this?

Thank

Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Excel Data - 11/28/2007 14:41:32   
How are you connecting to the DB? What path code?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to chadb)
chadb

 

Posts: 487
From: Kansas
Status: offline

 
RE: Excel Data - 11/28/2007 15:24:22   
I setup an odbc connection on the web server, then tried to create a new database connection in FP using the odbc connection. Is this what you wanted?

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Excel Data
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts