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.
The
following file is available for download from the Microsoft Download
Center:
Xslatezp.exe
(http://download.microsoft.com/download/mdac26/utility1/2.6/win98/en-us/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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=119591/EN-US/
)
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:
- Asks the user to enter the SQL Server name, Login ID and
password.
- Generates the SQL Server data source name (DSN)
'XslateSQLDSN'.
- Creates the Microsoft Access database (Xslate.mdb) and the
Microsoft Access DSN 'XslateAccessDSN'.
- 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
- 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'.
- 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.
- Cleans the remnants of the application, namely, the
Microsoft Access database, the Microsoft Access and SQL Server
DSN's.