Xslatezp.exe Data Translation using JET as a Medium

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:
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: 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.