问题描述
Hello Guys，
我正在寻找MS Access查询的替代方案。我需要这个的原因是我正在将所有内容从MS Access移动到SQL服务器。在我有MS Access DB和基于C＃的表单之前，在表中插入东西。然后 - 在同一个数据库中（使用Create table查询和常规查询）我构建报告，将其链接到excel并绘制pivot - 通常的业务内容。 （在MS Access DB的excel查询中用作数据源）
现在 - 我需要将所有内容从MS Access移动到SQL服务器。我重写了表单，一切都很好，除了创建表查询和常规查询部分，我找不到实现的方法。有谁知道SQL服务器是否有类似于MS Access quries的东西，可以直接链接到Excel？我认为存储过程可以很方便，但在网上找到一个很好的例子似乎是一个痛苦但是...
提前谢谢！
PS：任何建议，建议赞赏！
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!
推荐答案
这篇关于MS SQL Server Express中的MS Access Query替代方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！