PRB: No Overwrite Alert When Exporting to Xbase FileArticle ID: Q137935
SYMPTOMS
When you export a table to a dBASE, Paradox, or FoxPro file, the table name is truncated to 8 characters with a 3-character extension. For example, a table called OrderDetails is changed to ORDERSDET.DEF when exported to a dBASE III file. If a file of the same name already exists in the same folder, the older file is automatically overwritten by the exported table. You do not receive a warning message that the file will be overwritten. CAUSE
RESOLUTION
STATUS
MORE INFORMATION
1. Open the sample database Northwind.mdb. 2. In the Database window, click the Tables tab and select the Order Details table. 3. On the File menu, click Save As/Export. 4. In the Save As dialog box, click to select "To an External File or Database", and then click OK. 5. In the "Save Table 'Order Details' in" dialog box, under Save As Type, select dBASE III (*.dbf), and then click Export. Note that a file named ORDER DE.DBF is created. 6. Create a new, empty table and name it Order Details 2. 7. Repeat steps 2-5 to export the Order Details 2 table to the same folder as ORDER DE.DBF. 8. After exporting the Order Details 2 table, start Windows Explorer. 9. Locate the folder that contains the ORDER DE.DBF file. Open ORDER DE.DBF in an application that supports the *.DBF format. Note that the database is empty because the Order Details table was automatically overwritten with the Order Details 2 table. Paradox and dBASE are manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.
REFERENCES
|
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.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.
KBCategory: kb3rdparty
KBSubcategory: IsmXbase
Additional reference words: 7.00