Click here to Skip to main content
15,943,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello Guys,
I am looking for an alternative to MS Access queries. The reason I need this is that I am moving everything from MS Access into SQL server. Before I had MS Access DB and C# based form that inserts stuff in the table. Then - out of the same database (using Create table queries and regular queries) I build the report, link it into excel and draw pivot - usual business stuff. (In excel query from the MS Access DB is used as a data source)
Now - I need to move everything from MS Access to SQL server. I have rewrote the form and everything is fine except the create table query and regular query part, which I can't find a way to implement. Does anyone know if SQL server has anything similar to MS Access quries, that could be directly linked into Excel? I thought that stored procedures could be handy there but finding a good example on the net seems to be a pain in a but...

Thanks in advance!

P.S.: any advice, suggestion appreciated!
Posted

1 solution

Stored procedures are a good way forward. You can run them from Excel directly or populate the excel workbook from the results in C# ... your choice
Assuming you want to link the spreadsheet ...

Here's one example
http://stackoverflow.com/questions/12693967/table-in-excel-from-sql-server-stored-procedure-with-parameter-field-in-workbook[^]

and another walkthrough http://www.pawlowski.cz/2011/01/stored-procedure-data-source-excel/[^]

You can create tables in SPs - Dynamic Table Creation in SQL Server 2008 using stored procedure[^]
 
Share this answer
 
Comments
MK-Gii 28-Nov-13 9:32am    
Got it - very good examples. Thanks!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900