ACC: TransferText Can't Import Data into Enabled 2.0 Database
ID: Q160501
|
The information in this article applies to:
-
Microsoft Access versions 7.0, 97
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you use TransferText in a macro or in a Visual Basic procedure to
import data into an enabled Microsoft Access 2.0 database in Microsoft
Access 7.0 or 97, you receive may the message:
You can't import objects into a database created in an earlier version
of Microsoft Access.
This problem does not occur if you use TransferText to import data into an
enabled Microsoft Access 7.0 database in Microsoft Access 97.
RESOLUTION
You can work around this error message in two ways:
- Use Microsoft Access 2.0 to import the data into the database.
- Convert the Microsoft Access 2.0 database to the version of Microsoft
Access you are using.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0
and 97.
MORE INFORMATION
Steps to Reproduce Behavior
- Using Notepad or another text editor, create the following new text
file and save it as C:\My Documents\Customer.txt.
"ALFKI","Alfreds Futterkiste"
"ANATR","Ana Trujillo Emparedados y helados"
"ANTON","Antonio Moreno Taquerias"
- Start Microsoft Access 2.0 and create a new database called
Transfer.mdb.
- Create the following new table in Design view:
Table: Customers
-------------------------------
Field Name: CustomerID
Data Type: Text
Field Size: 5
Indexed: Yes (No Duplicates)
Field Name: CompanyName
Data Type: Text
Field Size: 255
Table Properties: Customers
-------------------------------
PrimaryKey: CustomerID
- Save and close the Customers table.
- On the File menu, click Imp/Exp Setup.
- Without modifying the default values in the Import/Export Setup dialog
box, click the Save As button and save the specification as Cust. Click
OK to close the dialog box.
- Create the following new macro called ImportCustomers:
Macro: ImportCustomers Action
-------------------------------------------
TransferText
ImportCustomers Actions
-------------------------------------------
TransferText
Transfer Type: Import Delimited
Specification Name: Cust
Table Name: Customers
File Name: C:\My Documents\Customer.txt
Has Field Names: No
- Save the macro, and then run it.
- Open the Customers table in Datasheet view and verify that it contains
the three records from the text file you created in step 1.
- Delete all three records from the table.
- Close the table, and then quit Microsoft Access.
- Start Microsoft Access 7.0 or 97, and open the Transfer.mdb database.
- In the Convert/Open Database dialog box, click Open Database. Click OK
when you see the message that you can't make changes to the database
objects.
- Click the Macros tab in the Database window and run the ImportCustomers
macro. Note that the macro fails, and you receive the error message:
You can't import objects into a database created in an earlier
version of Microsoft Access.
REFERENCES
For more information about importing or linking data in an enabled
database, please see the following article in the Microsoft Knowledge Base:
Q135372 ACC: Cannot Import/Link Data in Enabled Database
For more information about enabling databases, search the Help Index for
"enabling databases created in previous versions," and then "About opening
a previous-version database without converting it."
For more information about using the TransferText action or TransferText
method, search the Help Index for "TransferText action" or TransferText
method," or ask the Microsoft Access 97 Office Assistant.
Keywords : kberrmsg kbusage CnvOthr
Version : 7.0 97
Platform : WINDOWS
Issue type : kbbug