| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel database query referencing data in the same workbook
Folks,
Excel always asks me for a filename when I want to use Excel as the database source, in particular a different worksheet in the same workbook I'm editing. If I specify a fully qualified UNC name, which is an absolute path and filename, and I move the file, what will happen? Can't just tell Excel that the database source is the same workbook? How would I make a reference to the same workbook, with something similar to a relative pathname and filename? Regards kpiq |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel database query referencing data in the same workbook
BTW, I know the basics of SQL so don't be afraid to use SQL to demonstrate
your point. kpiq "kpiq" wrote: Folks, Excel always asks me for a filename when I want to use Excel as the database source, in particular a different worksheet in the same workbook I'm editing. If I specify a fully qualified UNC name, which is an absolute path and filename, and I move the file, what will happen? Can't just tell Excel that the database source is the same workbook? How would I make a reference to the same workbook, with something similar to a relative pathname and filename? Regards kpiq |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data via Database Query | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
