Xslatezp.exe Data Translation using JET as a Medium (196379)


The information in this article applies to:

  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • The Microsoft Foundation Classes (MFC), when used with:
    • Microsoft Visual C++, 32-bit Enterprise Edition 5.0
    • Microsoft Visual C++, 32-bit Enterprise Edition 6.0
This article was previously published under Q196379

SUMMARY

Xslatezp.exe is a self-extracting executable that performs data translations between Microsoft Access, Microsoft FoxPro, Microsoft SQL Server, and Microsoft Excel.

This article demonstrates translation of data from one database format to another using Microsoft Foundation Class (MFC) ODBC. You use the JET engine as an interface to perform the data translations. Essentially, ODBC accesses data from a preexisting data store. This sample describes how to create this data store programmatically and dynamically, in a format different from the source using MFC ODBC and JET.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

Xslatezp.exe

Release Date: Feb-20-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Sample File Information


    File Name               Size
    -----------------------------------
    Xslate.dsp              4,032 bytes
    Xslate.dsw                535 bytes
    Xslate.plg                811 bytes
    Xslate.cpp              5,208 bytes
    Xslate.ncb             33,792 bytes
    Xslate.opt             53,760 bytes
    Readme.txt
The sample performs translations between Microsoft Access, Excel, FoxPro, and SQL Server data stores. This project is assuming that your working folder for FoxPro databases is F:\Projects\ODBC\Xslatezp. Please change this on line number 61 of the code, or create this folder path.

NOTE: The FoxPro driver doesn't accept ".\" as a path.

The sample works as follows:
  1. Asks the user to enter the SQL Server name, Login ID and password.
  2. Generates the SQL Server data source name (DSN) 'XslateSQLDSN'.
  3. Creates the Microsoft Access database (Xslate.mdb) and the Microsoft Access DSN 'XslateAccessDSN'.
  4. Creates a Microsoft Access table 'XslateA' in 'Xslate.mdb' composed of three fields and inserts a 100 records. The fields are as follows:
          Field Name    Data type
      -----------------------

      Field1        Counter
      Field2        Text
      Field3        Long
  5. Exports this table to an Excel spreadsheet 'XslateX.xls' with the named range 'XslateX1', a FoxPro table 'XslateF.dbf', and a SQL Server table 'XslateS'.
  6. Translates the FoxPro table 'XslateF.dbf' to SQL Server 'XslateS1', the SQL Server table 'XslateS1' to Excel spreadsheet 'XslateX.xls' with named range 'XslateX2', and the Excel named range 'XslateX2' to a FoxPro table 'XslateF1.dbf'. This results in the following data stores:

    • SQL Server tables XslateS, XLateS1 in the SQL Server Pubs database.
    • FoxPro 3.0 tables XslateF.dbf, XslateF1.dbf in the current project directory.
    • Excel named ranges XslateX1, XslateX2 in the spreadsheet XslateX.xls created in the current project directory.
  7. Cleans the remnants of the application, namely, the Microsoft Access database, the Microsoft Access and SQL Server DSN's.
Modification Type:MinorLast Reviewed:8/10/2004
Keywords:kbdownload kbDatabase kbfile kbinfo kbJET KB196379 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.