How to Create MS Access Database from MS Excel Using DAO (151566)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q151566 SYMPTOMS
In some cases, you may want to create a Microsoft Access database from a
Microsoft Excel for Windows 95 version 7.0 workbook, but are not able to
use Access Links. While the preferred method of moving a Microsoft Excel
workbook into Microsoft Access is to use Access Links, you can also use
data access object (DAO).
CAUSE
The reasons for not being able to use Access Links include (but are not
limited to) the following:
- Microsoft Access for Windows 95 version 7.0 is not installed on the
computer.
- There are not enough system resources to have Microsoft Excel and
Microsoft Access loaded at the same time.
WORKAROUND
You can use data access objects (DAO)to create any version of a Microsoft
Access database. Although this method is not as complete as Access Links,
you can use it to create a Microsoft Access database from a Microsoft Excel
workbook. This method should be used only if you are experienced with
Visual Basic for Applications and are familiar enough with Microsoft Access
databases to be able to edit the tables that are created by this code.
Some things that you may need to change are the data types of each field
and whether or not you want indexing.
REFERENCESMicrosoft Access 97
For more information about creating indexes, click the Index tab in
Microsoft Access Help, type the following text:
and then double-click the selected text to go to the "Create an index to
find and sort records faster."
Microsoft Access 7.0
For more information about indexing, click Answer Wizard on the Help menu
in Microsoft Access 7.0, type Index in the
Search box, and click "Decide if and when to use an index."
Microsoft Access 2.0
For more information about indexing, click Search on the Help menu in
Microsoft Access version 2.0, type Index in
the Search box, click "Index (see also indexes)," and then click "Creating
an Index" under Topics.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB151566 |
---|
|