ACC: TransferText Can't Import Data into Enabled 2.0 Database

• 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.

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

1. 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"
   

2. Start Microsoft Access 2.0 and create a new database called Transfer.mdb.

3. 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
   
   

4. Save and close the Customers table.

5. On the File menu, click Imp/Exp Setup.

6. 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.

7. 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
   
   

8. Save the macro, and then run it.

9. Open the Customers table in Datasheet view and verify that it contains the three records from the text file you created in step 1.

10. Delete all three records from the table.

11. Close the table, and then quit Microsoft Access.

12. Start Microsoft Access 7.0 or 97, and open the Transfer.mdb database.

13. 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.
    

14. 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:

   ARTICLE-ID: Q135372
   TITLE     : ACC: Cannot Import/Link Data in Enabled Database