ODBC to the same file?

  • Thread starter Thread starter rondo
  • Start date Start date
R

rondo

I want to use one Excel-worksheet as an ODBC source for another sheet in the
same workbook. This connection is not to a static file (no problem), but to
"myself" so that I can move the document from C:\My Documents to O:\Someone
else\files\

Anyone?
 
rondo said:
I want to use one Excel-worksheet as an ODBC source for another sheet in the
same workbook. This connection is not to a static file (no problem), but to
"myself" so that I can move the document from C:\My Documents to O:\Someone
else\files\

Anyone?
Click to expand...

Has anyone done this?
 
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top