Excel database query referencing data in the same workbook

K

kpiq

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
 
K

kpiq

BTW, I know the basics of SQL so don't be afraid to use SQL to demonstrate
your point.
kpiq
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Absolute and Relative Cell References 1
Change a cell reference from relative to absolute 2
Macro Copy Workbook Query 2
Link one worksheet in a workbook to another worksheet in same work 1
Prevent multiple workbooks in same Excel instance 8
Testing if data already imported 3

Top