Hi Manoj.. i have a slightly complicated SQL query with couple of Inner joins and group by functions. i am able to execute my query in SQL studio however when i copy the code with the respective question marks to set up parameters i am getting the message "parameters are not allowed in queries that can't be displayed graphically". I do not have any VBA running in the background. Are you able to advice?
I am getting converting failed when converting date and or time from character string in excel while fetching data into excel by using between command...please help
As far as I know you can assign just 1 cell for 1 parameter. But if you need a list of values in multiple cells to be passed to a parameter then you can create a formula in excel that can read all values from cells and concatenate them to a single cell and read that 1 cell value.
sorry, you can't query with just excel and within excel. You will need a Database as a query engine. Excel does not support any interface to fire and understand SQL queries. But you can use MS Access though !!!
Got it, I had to View > Criteria > Double-Click Values to select a column to filter, type After [PARAMETERNAME] then it allowed me to continue following your steps :D THANK YOU
This will work with simple JOIN queries, but if you have a complex query with several JOINS and filters then try creating a Stored Procedure and execute it from here instead of the query. Check my other video for the same.
OK, for this you need to write a macro, which will concatenate the 1000 values in A column of excel and pass as CSV parameter value to the Stored Procedure and repopulate the retrieved values from Database table in 2nd tab.
row by row will be possible, but it will be a slow process due to multiple rounds from excel to SQL and back to excel. Why don't you do it in SQL Server instead of Excel? Create a SP, read excel data from Linked Server or OPENQUERY(), and rewrite the excel back by using same Linked Server.
Please subscribe for more videos !!!
please give me file excel, tks!
Sir daily i do in excel work basically i want 5rows but the data is 50row how to use sql easily and quickly to execute my excel daily reort file
Thank you for showing this, I have been trying to find how to achieve this for ages.
Excellent approach sir. Thank you
Just what I needed! I was having trouble understanding the parameter values.
Thanks a lot.
Never thought about this kind of feature in Excel
Thanks. Very Useful one
Thank you very much sir Manoj!
Thanks for the useful, straight to the point info
Great tutorial - exactly what I was looking for!
Thank you so much .. this is extremely helpful
Thank you so much.
Just what I was looking for. Thanks!
Great tutorial - Can you do this in version 365?
Good one Manoj. I loved it. How can I do this in Office 365? I don't find the options.
Hi Manoj.. i have a slightly complicated SQL query with couple of Inner joins and group by functions. i am able to execute my query in SQL studio however when i copy the code with the respective question marks to set up parameters i am getting the message "parameters are not allowed in queries that can't be displayed graphically". I do not have any VBA running in the background. Are you able to advice?
Great video thanks, but i have another issue. I need to keep data only in query editor without importing them to the list. How can i do that?
Hello Manoj Thanks for the video. Is there a way where I can clear the parameter and bring all data if needed.
Hi Manoj, thanks for the info. I'm able to do this but when I open excel again that parameters are not assigned . Any solution for this?
I am getting converting failed when converting date and or time from character string in excel while fetching data into excel by using between command...please help
what a good!!! how to apply to store procedure with parameter? it could'nt work ...help me^^
can we select multi cell as parameters while linking SQL to excel .. hoping I will get answer
As far as I know you can assign just 1 cell for 1 parameter. But if you need a list of values in multiple cells to be passed to a parameter then you can create a formula in excel that can read all values from cells and concatenate them to a single cell and read that 1 cell value.
Hi , if my sql table is getting updated automatically and can i give the date range beyond the end date parameter?
Good video for SQL. Can we rename parameter1 to 'Start Date' please?
i want to do a sql query, but the data is in an excel table not in a database server, how can i use a sql query on an excel table?
sorry, you can't query with just excel and within excel. You will need a Database as a query engine. Excel does not support any interface to fire and understand SQL queries. But you can use MS Access though !!!
youre damn genius
Sir can I use parameter method SQL data connection in Excel
I didn't get you, can you explain?
Can I do or not pls confirm
Great solution, but.. I'm not allowed to use parameters - how do I enable them?
Got it, I had to View > Criteria > Double-Click Values to select a column to filter, type After [PARAMETERNAME] then it allowed me to continue following your steps :D THANK YOU
this won't work with queries that use JOIN - is there any workaround for that?
This will work with simple JOIN queries, but if you have a complex query with several JOINS and filters then try creating a Stored Procedure and execute it from here instead of the query. Check my other video for the same.
Sir I have connections with data collection with excel. Refresh is very slowly
Dear Sir, I tried it, but data nor received in excel, Only Column name received, data not.
HI Friend!!
Greetings from Colombia.. If I could I give you 100 Likes👍
Hi Manoj, I need to read A1 to A1000 one by one and populate on another sheet, how to do it
For this you don't need SQL, it can be done by a simple macro !!!
SQL with Manoj Hi Manoj, I have to read A1 to A1000 and extract two columns from the table, then populate in the second tab.
OK, for this you need to write a macro, which will concatenate the 1000 values in A column of excel and pass as CSV parameter value to the Stored Procedure and repopulate the retrieved values from Database table in 2nd tab.
Manoj Pandey hi Manoj, will it be possible to read row by row.
row by row will be possible, but it will be a slow process due to multiple rounds from excel to SQL and back to excel. Why don't you do it in SQL Server instead of Excel? Create a SP, read excel data from Linked Server or OPENQUERY(), and rewrite the excel back by using same Linked Server.
98 records
Video quality not good to view. Can you share quality video
What did you say?