![]() If the field layout is not consistent between the DBF and the ODBC connection file, data will be misplaced causing problems during import or matching. To import ODBC data into an existing mDesktop Main File, the DBF structure of the Main File must be consistent with the fields selected in the ODBC connection. Importing ODBC Data into an Existing Main File However, starting the Setup Wizard via the Single File or Two File button will allow you to specify an ODBC Connection file or create a new one, as discussed in "Creating an ODBC Connection file". Choosing the latter method will prompt you for the file that you wish to import, so you can only use this if you have previously created an ODBC Connection (*.ODB) file. The mDesktop Setup Wizard can be launched by selecting one of the file wizards or by selecting the Setup Wizard option located under the Import menu. Using mDesktop's Setup Wizard to Import ODBC Data Once you have created an ODBC Connection file, you can import the data selected via mDesktop's Setup Wizard or by importing it into an existing mDesktop Main File. You can select fields individually by double-clicking, select a block of fields by highlighting them and clicking "Add", or use the Add All button. This feature can help improve processing time by limiting the size of large files with numerous fields that are unrelated to the matching process, as well as reducing the setup time required in mDesktop. When importing a table or view, you can choose what fields you would like to import. This defines the data that will be imported. Selecting a TableĪfter choosing a data source, select a table or view from the drop-down list of available tables. If prompted, enter the Login ID and Password for the data source. To choose an ODBC Data Source, click the button. The ODBC Connection Manager window is then displayed as follows. You can create an ODBC Connection file by selecting the ODBC Connection Manager option from the File menu or by choosing the ODBC option in the mDesktop Import Manager window, as shown below (to access the ODBC Connection Manager window - click "…" after choosing the ODBC radio button). The following sections explain mDesktop's ODBC functionality in detail, covering all of the major options and processes. On output, the user can choose to create a new table, overwrite an existing table, or delete records from within a table and reassign orphaned records in a child table. mDesktop uses an ODBC Connection file to import the required information from the chosen data source, as well as export data back to the original source database. The user can select which fields from the table or view they would like to import. When importing data, the user must create a single table or view containing the data which is to be read into mDesktop – for Access, this can be a query. Supported ODBC drivers include the standard ones for SQL Server, mySQL, DB2, Oracle and Access. MDesktop can read and export data using standard ODBC connections.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |