Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result set scrolling. Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html
Enter the desired name for the table after its import into the MySQL server, and click OK. Important Make sure that the information that you are exporting to the MySQL table is valid for the corresponding MySQL data types. Values that are valid ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-import.html
Microsoft Access connects to the MySQL server and displays the list of tables (objects) that you can import. To import tables from MySQL to Access, follow these instructions: Open the Access database into which that you want to import MySQL data.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
Microsoft Access connects to the MySQL server and displays the list of tables that you can link to. You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and columns. You can use Microsoft Word and Microsoft Excel to access information ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools.html
Once you have configured your Connector/ODBC DSN, you can access your MySQL database through any application that supports the ODBC interface, including programming languages and third-party applications. This section contains guides and help on ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
ODBC is a standardized API that enables connections to SQL database servers. ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. It was developed according to the specifications ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-windows-dll.html
If you have downloaded the zipped DLL package: Unzip the installation files to the location you want it installed. Run the included batch file to perform an installation from the current directory and registers the ODBC driver. Alternatively to the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-datatypes.html
The following table illustrates how Connector/ODBC maps the server data types to default SQL and C data types.