Use of CopyObject or TransferDatabase

[simsjr]

Hi there,

We've tried using both CopyObject and TransferDatabase to export a table
from one Access mdb to another. These databases are located on different
network drives. One database is Access 97, the other is Access 2000 - and we
want the 2000 database to export to the 97 database.

So far, we've been able to create a link table in the 97 DB to a table in a
2000 DB using CopyObject, but we want a full export - not a link - and can't
seem to get it to work.

Anyone know the correct VBA to do this?

 

['69 Camaro]

Hi.

One database is Access 97, the other is Access 2000 - and we
want the 2000 database to export to the 97 database.

Access 97, which uses Jet 3.5, can't read the Access 2000 tables. Access
2000 and later versions use Jet 4.0, which is incompatible with Jet 3.5.
Access 2000 databases can link to the tables in Access 97, but not the other
way around. Access 97 can't read the data stored in unicode in the Access
2000 database, even if one creates a connection string that points to the
table in the Access 2000 database (the link you mentioned).

If you can't upgrade the Access 97 database to Access 2000, then you'll need
to export the Access 2000 table to a text file (*.CSV, *.TXT, or *.TAB),
then import this file into the Access 97 database. Create an export
specification in the Access 2000 database and an import specification in the
Access 97 database to help automate this.

See the Access Help topic on the TransferText method for the syntax.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)