Connection with Sql and Excel

[Nishant Chury]

Need help to with connection of Sql and excel, also to create a macro where user inputs start date and end date which automatically gets updated in the query for execution.

Thanks,

 

[Deepak]

Pls upload a sample file with explained query.

 

[Nishant Chury]

i am looking out for a template like stuff, where in i can just add the db, username,password and it gets connected to the db,

for the query may be a sample query where the user inputs 2 dates which updates the query for exceution.

query e.g.

select * from Student where start_date ="User input" & End_date = "User Input"

 

[NARAYANK991]

Hi Nishant ,

You will find the following an invaluable resource :

http://www.dicks-clicks.com/excel/ExternalData.htm#What_is

Narayan

 

[jeffreyweir]

Craig Hatmaker's Beyond Excel is my 'go to' blog where SQL is concerned.
https://sites.google.com/site/beyondexcel/

 

[pakilprogramador]

see this file