Microsoft KB Archive/196379

= Xslatezp.exe Data Translation using JET as a Medium =

Article ID: 196379

Article Last Modified on 8/10/2004

-

APPLIES TO

 Microsoft Data Access Components 2.0 Microsoft Data Access Components 2.1 Microsoft Data Access Components 2.5 Microsoft Foundation Class Library 4.2, when used with:  Microsoft Visual C++ 5.0 Enterprise Edition

 Microsoft Visual C++ 6.0 Enterprise Edition </li></ul>

-

<div class="notice_section">

This article was previously published under Q196379

<div class="summary_section">

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.

<div class="moreinformation_section">

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
<pre class="fixed_text"> 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: <ol> Asks the user to enter the SQL Server name, Login ID and password.</li> Generates the SQL Server data source name (DSN) 'XslateSQLDSN'.</li> Creates the Microsoft Access database (Xslate.mdb) and the Microsoft Access DSN 'XslateAccessDSN'.</li>  Creates a Microsoft Access table 'XslateA' in 'Xslate.mdb' composed of three fields and inserts a 100 records. The fields are as follows: <pre class="fixed_text">     Field Name    Data type ---

Field1       Counter Field2       Text Field3       Long </li> 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'.</li> 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.</li> FoxPro 3.0 tables XslateF.dbf, XslateF1.dbf in the current project directory.</li> Excel named ranges XslateX1, XslateX2 in the spreadsheet XslateX.xls created in the current project directory.</li></ul> </li> Cleans the remnants of the application, namely, the Microsoft Access database, the Microsoft Access and SQL Server DSN's.</li></ol>

Additional query words: Xslatezp

Keywords: kbinfo kbdownload kbdatabase kbfile kbjet KB196379

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.