| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL server - Excel
Hi!
I know how to pull data from SQL server to Excel but I do not know how to pass parameters to query from excel cells. Example: Cell A2 is begin date, cell B2 is end date. How can I pass those two dates to Microsoft Query into between function? Thank you! /Markonni |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL server - Excel
MarkonniMarkonni wrote:
Try here http://www.dicks-clicks.com/excel/Ex...htm#Parameters -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Hi! I know how to pull data from SQL server to Excel but I do not know how to pass parameters to query from excel cells. Example: Cell A2 is begin date, cell B2 is end date. How can I pass those two dates to Microsoft Query into between function? Thank you! /Markonni |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel and SQL Server | Excel Discussion (Misc queries) | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
| Excel as RTD server? | Excel Programming | |||
Linear Mode
