• 在access 2007 中进行sql query


    1. 发现了两个小工具(都是通过odbc来访问)
    1.1 winsql (其中lite是免费版,需要上网站上申请注册号)
    1.2 query tool


    2. Creating a SQL Query in Access 2007

    by rhyttinen on September 17, 2008

    SQL (Structured Query Language) is a powerful database language used in queries. Each query that you create has an underlying SQL statement, which you can view or edit by clicking theViewbutton arrow on the Home Ribbon and then click SQL view. If you know SQL, you can create Select Queries as well as Action Queries by typing in the SQL statement in the SQL window.

    An example of a simple select SQL statement would be: SELECT * FROM tblCustomers. This statement would return all records from tblCustomers. If you want to delete all records from tblCustomers from the state of Michigan, the equivalent SQL statement statement would read: DELETE * FROM tblStudents WHERE State = “MI”.

    To Create a SQL Query

    1. Click theCreate tabon the Ribbon.

    2. Click theQuery Designbutton on the Other group.

    3. In theShow Table dialog box, click theClose button.

    4. Click thearrowon the View button and then clickSQL View.

    5. Type your SQL commands to create the query.

    6. Click theRun button on the Ribbon to execute the query.

    3. 64位mdb访问,ACCESS

    Provider=Microsoft.Jet.OLEDB.4.0
    Provider=Microsoft.ACE.OLEDB.12.0
  • 相关阅读:
    最近想读的书想做的事
    syslogng 正确配置udp接受端口
    (转)iPhone重绘机制drawRect
    .Net工具整理
    用系统的网格还是用自己的网格
    将主关键字加强为适应多个
    onblur与onbeforedeactivate的区别
    模式窗口中无法转向
    实现获取客户端的MAC地址(3)
    onkeypress、onkeydown、onkeyup三事件的区别
  • 原文地址:https://www.cnblogs.com/IS2120/p/6746015.html
Copyright © 2020-2023  润新知