ACC: How to Import Several dBASE Databases at Once 95/97 (141611)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q141611 SUMMARY
Many new Microsoft Access 7.0 and 97 users want to import data immediately
from the systems they are currently using. The Import dialog box in
Microsoft Access is designed to import one table at a time. Most of the
time, this capability is enough. However, some users may have numerous
tables to import, or they may want to import multiple tables regularly. To
do so, they can create a batch process in a Visual Basic for Applications
procedure to import multiple dBASE databases at once. This article shows
how to create such a procedure.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
REFERENCES
For more information about TransferDatabase, search the Help Index for
TransferDatabase method or ask the Microsoft Access 97 Office Assistant.
For more information about batch importing dBASE databases in Microsoft
Access version 1.x or 2.0, please see the following article in the
Microsoft Knowledge Base:
88764 ACC: How to Import Several dBASE Databases at Once (1.x/2.0)
dBASE III, dBASE III PLUS, and dBASE IV are manufactured by Borland
International, Inc., a vendor independent of Microsoft; we make no
warranty, implied or otherwise, regarding the performance or reliability of
these products.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kb3rdparty kbhowto kbProgramming KB141611 |
---|
|