| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you store data in Excel as a database?
I don't know how you'd add a where statement. Anyone? I discovered this ... To do a selective query, you should use a named range with a header row that is the column names, and then query the column name SELECT * FROM range_name WHERE Name = 'Joe' AND CtyCode = 'GB'; Also you can filter the data from the Recordset. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| thru form update data store in excel | Excel Worksheet Functions | |||
| Use excel with java to store data | Excel Programming | |||
| 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 | |||
| database to store data entered from a spreadsheet? | Excel Programming | |||
| Using controls in excel to store data | Excel Programming | |||
![gimme_this_gimme_that@yahoo.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
