在MS Access中显示在SQL结果集中 [英] Displayin SQL resultset in ms access

问题描述

嗨.

我已经在ms access ..中创建了一个表单，该表单用于在sql表中搜索并根据搜索关键字来检索数据..
到目前为止，我已经完成了，但是主要的事情...

在ms Access中显示检索数据..不知道要执行此操作，请任何人帮助我执行此操作.


感谢

Hi.

I have created a form in ms access.. that is to search in sql table and retrieve data based on the search key word..
Upto this i have done but the main thing ...

displaying the retrieve data in ms access.. no idea to do this please anyone help me to do this.


Thanks

推荐答案

最简单的方法是通过ODBC将SQL Server表链接到Access项目.最初会有一些问题，因为SQL Server和Access使用的数据类型略有不同，但是在MSDN上进行一些快速搜索应该可以为您指明正确的方向.

要设置ODBC连接，请导航至:

Control Panel --> Administrative Tools --> Data Sources (ODBC)并单击系统选项卡.

如果您以前没有做过此操作，那么我强烈建议您在Google上进行查找，这样您将被指示正确的方向.

希望这对您有所帮助.如果您还有其他问题，请告诉我.

-欢呼

The easiest way is to link your SQL Server tables to your Access project via ODBC. There will be a few problems intially because SQL Server and Access use slightly different data types but a few quick searches on MSDN should point you in the right direction.

To setup an ODBC connection, navigate to:

Control Panel --> Administrative Tools --> Data Sources (ODBC) and click on the system tab.

If you have not done this before then I highly recommend that you look it up on Google and you will be pointed in the right direction.

Hope this helped you in some way. Let me know if you have any other questions.

-- Cheers

这篇关于在MS Access中显示在SQL结果集中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！