DOCUMENT:Q173879  26-AUG-1999  [foxpro]
TITLE   :HOWTO: Importing an Access Table into FoxPro for the Mac
PRODUCT :Microsoft FoxPro
PROD/VER:MACINTOSH:2.6a,3.0b
OPER/SYS:
KEYWORDS:kbHWMAC kbvfp

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

 - Microsoft Visual FoxPro for Macintosh, version 3.0b 
 - Microsoft FoxPro for Macintosh, version 2.6a 
-------------------------------------------------------------------------------

SUMMARY
=======

Often, you have information in an Access table that needs to be imported into a
FoxPro 2.x for the Macintosh or Visual FoxPro 3.0b for the Macintosh table.
However, neither version of FoxPro offers a command that directly imports an
Access table into a .dbf file nor is there a Macintosh-based ODBC driver
available to read the Access data. This article provides several methods of
accomplishing this task.

MORE INFORMATION
================

Since neither Visual FoxPro 3.0b for the Macintosh or FoxPro 2.x for the
Macintosh has a method of importing Access tables, you must use the
functionality of Access to create the .dbf table. Since Access is a Windows
product, this article assumes the user has access to a Windows 95 or Windows NT
machine.

The first method assumes that you have Visual FoxPro 3.x or 5.x for Windows.
Since both versions of Visual FoxPro for Windows have ODBC drivers that
interface with Access tables, one can create a remote view within Visual FoxPro
to read the Access data and then save it to a .dbf file. The second method uses
Access to save the file in a .dbf format. This method does not require one to
install Visual FoxPro 3.x or 5.x for Windows.

First Method
------------

1. Create a new database called Ztest in Visual FoxPro 3.x or 5.x.

2. In the database, right-click and select New Remote View.

3. Select New View and then click Available data sources.

4. Select the proper Access driver from the list. In this case, Access 7.0
   database and click OK.

5. If Microsoft Office 97 is installed, open the employee table contained in the
   Northwind.mdb (an Access database container) located in the program
   Files\Microsoft Office\Office\Samples folder. The exact path on a machine
   depends on the location of Microsoft Office.

6. After adding the Employees table, click Close.

7. Add the necessary fields using the Fields tab and execute the view.

8. Once the view returns the data, press the CTRL and F2 keys simultaneously to
   invoke the Command window and type the following:

         COPY TO HOME()+"Temp.dbf"

9. In the Command window type the following (without the quotation marks):

         "USE ?"

   Navigate to the Visual FoxPro home directory and locate Temp.dbf and select
   it.

10. Type "BROWSE" (without quotation marks) in the Command window to see the
   Visual FoxPro table. Now copy the file to a disk or place it in a device
   that both a Windows and a Macintosh machine can access. Finally, copy the
   file to the appropriate folder on the Macintosh.

Second Method
-------------

1. Start Microsoft Access 97.

2. Open the Access table that needs to be converted to a FoxPro table.

3. From the File menu, select Save As/Export.

4. Select "To an external database" and click OK.

5. In the Save as Type list box, select either Microsoft FoxPro 2.6 (*.DBF) or
   Microsoft FoxPro 3.0 (*.DBF) and save the file.

6. Place the new .dbf file on a disk or a device that is readable by a Macintosh
   machine. Copy the file to the desired Macintosh folder and open the file with
   FoxPro.

REFERENCES
==========

Access Online Help

Additional query words: Access

======================================================================
Keywords          : kbHWMAC kbvfp 
Technology        : kbHWMAC kbOSMAC kbVFPsearch kbAudDeveloper kbFoxproSearch kbFoxPro260aMac kbVFP300bMac
Version           : MACINTOSH:2.6a,3.0b
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.

Copyright Microsoft Corporation 1999.