| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from database via web
Okay, it turns out the simplest way is this:
Publish a web page with the data in an html table or tables, then use a web query in Excel to get the data (QueryTable, WebSelectionType = xlSpecifiedTables, etc). That will allow us to update the data anytime, and vendors get the updated data the next time they open the workbook. Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming | |||
| Using Sum for database data | Excel Discussion (Misc queries) | |||
| how do you add a row of data like in a database | Excel Programming | |||
Threaded Mode
