Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL script to select another file in same folder
My code below needs another line to identify the workbook path is where the
folder where the workbook resides. SELECT data.heading1, data.heading2 FROM [Excel 8.0;HDR=Yes;database=.\book1.xls";].[Data] I would like this MS Query in Excel to link with the file book1.xls, which is located in the same folder as the open (active) workbook. However, the system thinks the activeworkbook path is that shown in my default settings (Tools-Options-General-Default Path). Thank you for your help. Thank ytou. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL script to select another file in same folder
Can't you just build it up
sFile = Activeworkbook.Path & Application.PathSeparator & "Book1.xls" sSQL = "SELECT data.heading1, data.heading2 FROM [Excel 8.0;HDR=Yes;database=." & sFile & "";].[Data]" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RiverGully" wrote in message ... My code below needs another line to identify the workbook path is where the folder where the workbook resides. SELECT data.heading1, data.heading2 FROM [Excel 8.0;HDR=Yes;database=.\book1.xls";].[Data] I would like this MS Query in Excel to link with the file book1.xls, which is located in the same folder as the open (active) workbook. However, the system thinks the activeworkbook path is that shown in my default settings (Tools-Options-General-Default Path). Thank you for your help. Thank ytou. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL script to select another file in same folder
Bob, I copy and pasted the new statements into the Microsoft Query (Excel's
Data - Import External Data -..Database Query) and got the message "Invalid SQL statement; expected Delete, Insert, Procedure, Select or Update". Is there another way? Thank you. "Bob Phillips" wrote: Can't you just build it up sFile = Activeworkbook.Path & Application.PathSeparator & "Book1.xls" sSQL = "SELECT data.heading1, data.heading2 FROM [Excel 8.0;HDR=Yes;database=." & sFile & "";].[Data]" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RiverGully" wrote in message ... My code below needs another line to identify the workbook path is where the folder where the workbook resides. SELECT data.heading1, data.heading2 FROM [Excel 8.0;HDR=Yes;database=.\book1.xls";].[Data] I would like this MS Query in Excel to link with the file book1.xls, which is located in the same folder as the open (active) workbook. However, the system thinks the activeworkbook path is that shown in my default settings (Tools-Options-General-Default Path). Thank you for your help. Thank ytou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Selecting the most recent file in a folder by Macro/VBA script | Excel Programming | |||
How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
"Folder Select" Dialogue - Opening multiple files from selected folder | Excel Programming |