LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel-SQL Connect

Hi,

I have a little problem with my excel-SQL connection.

In one cell of my excel doc is a date. example 2003-11-04

I want to pass that date into my sql query.

select * from database where date="value from table1!A1"

is this possible?
I need a solution, so that the User in Excel can choose the date and than
click run.

thx,
mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect excel(If I consider it as a database) with a websit SATABDI NATH Excel Discussion (Misc queries) 0 July 8th 08 12:34 PM
Excel cannot connect to web Ltat42a Excel Discussion (Misc queries) 0 May 29th 06 05:18 PM
How to connect two columns in Excel VBA?? [email protected] Excel Worksheet Functions 4 November 12th 05 11:26 AM
connect a form to excel database Kathy Excel Discussion (Misc queries) 5 October 10th 05 06:17 AM
Informatica Connect to Excel workbook Michael MacLachlan Excel Discussion (Misc queries) 0 December 3rd 04 11:15 AM


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"