Exporting a Table

ADOCE enables you to export tables from a Windows CE–based device to a desktop computer. The Export from Mobile Device to Database dialog box gives you the option to choose which tables on the device to convert to an Access database.

To export an ADOCE database

1. Connect the device to the desktop computer and open the Mobile Devices window.
   
   
2. Choose Export Database Tables on the Tools menu in the Mobile Devices window.

   The Export from Mobile Device to Database dialog box appears, showing the ADOCE tables on the connected device.

3. Choose the Browse button to select a Microsoft Access .mdb file.

   You also can type the path and file name in the Location box. If the file does not exist, ADOCE creates it for you.

4. Select the check boxes for the tables you want to export, and then clear the check boxes for the tables you do not want to export.

   ADOCE puts all the selected tables in the same .mdb file.

5. Select the Overwrite existing tables and/or data box if you want to replace tables in the .mdb that have the same names as selected ADOCE tables.
   
   
6. Choose OK to begin the conversion.

The following screen shot shows the Export from Database to Mobile Device dialog box.

The following options are available in the Export from Mobile Device to Database dialog box:

• Location text box

  This box specifies the Microsoft Access .mdb file in which to store selected tables. Type in a path and file name, or use the Browse button to select an existing file or change directories. The default database location and name is <Device Partner Folder>\Dbxx.mdb, where the number xx represents the next available number. If the file specified in the Location text box does not exist, ADOCE creates one.

• Select the tables to copy list box

  This list box shows every table that ADOCE can read, except the ADOCE system tables. Select the check box by a table name to select it for conversion. ADOCE places the selected tables in the same .mdb file.

• Overwrite existing tables and/or data check box

  If you have tables in the selected database with the same name as tables in the list, selecting this check box causes the existing tables to be replaced with the newly converted ones. Clearing this check box causes the converter to generate an error if it finds a table with the same name. You cannot merge the data in an ADOCE table with existing data in an Access table.

• Default button

  Choose this button to select the default tables for conversion. ADOCE automatically selects all tables.

• OK button and Cancel button

  The OK button starts the conversion of the selected tables. The Cancel button quits the conversion.

To export data from a device into an ODBC data source

1. Connect the device to the desktop computer and open the Mobile Devices window.
   
   
2. Choose Export Database Tables on the Tools menu in the Mobile Devices window.

   The Export from Mobile Device to Database dialog box appears.

3. Choose the Browse button.

   The Choose Your New Database’s Filename dialog box appears.

4. Choose ODBC Database in the Save as Type drop-down box.
   
   
5. Choose an ODBC data source.
   
   
6. Select the check boxes for the tables you want to export, and then clear the check boxes for the tables you do not want to export.
   
   
7. Select the Overwrite existing tables and/or data box if you want to replace tables in the existing database that have the same names as selected ADOCE tables.
   
   
8. Choose OK to begin the conversion.

For each .mdb file exported, the converter generates a log file named Ce2db.txt in the partner directory for the device, usually in C:\Program Files\Windows CE Services\Profiles\devicename.