KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q301081: HOW TO: Export a Table from Windows CE by Using eMbedded Visual

Article: Q301081
Product(s): Microsoft Visual Basic for Windows
Version(s): 3.0
Operating System(s): 
Keyword(s): kbenv kbGrpDSVB kbAudDeveloper kbHOWTOmaster
Last Modified: 23-FEB-2002

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft eMbedded Visual Basic, version 3.0 
-------------------------------------------------------------------------------

IN THIS TASK
------------

- SUMMARY

   - Requirements
- How to Export a Table from ADOCE to Microsoft Access
- Additional Information

- REFERENCES

SUMMARY
=======

With Microsoft(r) ActiveSync(r) 3.1 and ActiveX(r) Data Objects (ADO) for the
Microsoft Windows(r) CE operating system (ADOCE) 3.1 installed, you can manually
export tables from a Windows CE-based device to a desktop computer. This is
convenient if you update data in a single table in a database. This article
describes the steps to export tables from a Windows CE device to a Microsoft
Access database.

Requirements
------------

The following list outlines the recommended hardware, software, network
infrastructure, and service packs that you will need:

- Microsoft Access or Microsoft SQL Server
- Microsoft ActiveSync 3.1
- Microsoft Windows CE-based device

How to Export a Table from ADOCE to Microsoft Access
----------------------------------------------------

With Microsoft ActiveSync 3.1 and the ADOCE control installed, you can manually
export tables from a Windows CE-based device to a desktop computer. This is
convenient if you update data in a single table in a database, or if you want to
save time. It is faster to transfer selected tables in a database than to
transfer the contents of an entire database. In the "Export from Mobile Device
to Database" dialog box, you can choose which tables on the device to convert to
a Microsoft Access database.

To export an ADOCE database, follow these steps:

1. Connect the device to the desktop computer, and open the ActiveSync 3.1
  window.

2. On the Tools menu, click "Export Database Tables". The "Export from Mobile
  Device to Database" dialog box appears, which displays the ADOCE tables on
  the connected device.

3. To select a Microsoft Access .mdb file, click Browse. You can also type the
  path and file name in the Location text box. ADOCE creates the file if it
  does not exist.

4. Select the check boxes for the tables that you want to export, and clear the
  check boxes for the tables that you do not want to export. ADOCE places the
  selected tables in the same .mdb file.

5. Select the "Overwrite existing tables and/or data" check box to replace
  tables in the .mdb that have the same names as the selected ADOCE tables.

6. Click OK to begin the conversion.

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

To export data from a device into an Open Database Connectivity (ODBC) data
source, follow these steps:

1. Connect the device to the desktop computer, and open the ActiveSync 3.1
  window.

2. On the Tools menu, click "Export Database Tables".

3. In the "Export from Mobile Device to Database" dialog box, click Browse.

4. In the "Choose Your New Database's Filename" dialog box, in the Save as Type
  combo box, click ODBC Database.

5. Select an ODBC data source.

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

7. In the "Choose Your New Database's Filename" dialog box, select the
  "Overwrite existing tables and/or data" check box to replace tables in the
  existing database that have the same names as the selected ADOCE tables.

8. Click OK to begin the conversion.

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

Additional Information
----------------------

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

- Location text box:

  This text box specifies the Microsoft Access .mdb file in which to store the
  selected tables. Type 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 that is specified in the
  Location text box does not exist, ADOCE creates one.

- "Select the tables to copy" list box:

  This list box displays every table that ADOCE can read, except the ADOCE
  system tables. To select the table for conversion, select the check box by
  the table name. ADOCE places the selected tables in the same .mdb file.

- "Overwrite existing tables and/or data" check box:

  When you select this check box, if you have tables in the selected database
  with the same name as tables that appear in the window, the existing tables
  are replaced with the converted ones. If you clear this check box, the
  converter generates an error if it finds a table with the same name. You
  cannot merge the data in an ADOCE table with existing data in a Microsoft
  Access table.

- Default button:

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

- OK and Cancel command buttons:

  Click OK to start to convert the selected tables. Click Cancel to quit the
  conversion.

REFERENCES
==========

For more information, see the Embedded Developer Documentation on MSDN at:

  http://msdn.microsoft.com/library/wcedoc/embedanchor.htm
  (http://msdn.microsoft.com/library/wcedoc/embedanchor.htm)

You can download ActiveSync 3.1 from the following Microsoft Web site:

  http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp

You can download ADOCE 3.1 from the following Microsoft Web site:

  http://msdn.microsoft.com/code/sample.asp?url=/msdn-files/027/001/491/msdncompositedoc.xml

Additional query words:

======================================================================
Keywords          : kbenv kbGrpDSVB kbAudDeveloper kbHOWTOmaster 
Technology        : kbVBSearch kbAudDeveloper kbZNotKeyword2 kbVBeMbSearch kbVBeMb300
Version           : :3.0
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.