MS ACCESS 2003 Import/Export Question

[SamCec]

I have 2 MS Access 2003 databases (.mbd). For simplicity I will call these SDB1.mdb and RDB2.mdb.

SDB1 is a standard mdb database with approximately 350 records. RDB2.mdb has 0 records (I deleted all records from this database but DID NOT delete the field descriptions). RDB2.mdb was written to contain forms and queries,etc.

Rather than to redesign the forms and queries and needing to re-enter all of the data, I would like to export SDB1.mdb into (replace) RDB2.mdb. The one problem I know if is the table database field names/lengths are different. What I tried doing was to change some of the field names in SDB1.mdb to existing field names of RDB2.mdb. I tried Importing SDB1.mdb into RDB2.mdb with no success. I also tried just copying and pasting the data from SDB1.mdb to RDB2.mdb--NO SUCCESS. I also tried an append from SDB1.mdb to RDB2.mdb--AGAIN NO SUCCESS.

An important note about RDB2.mdb it has an AUTO-SEQUENCE NUMBER. SDB1.mdb does not have any sequence number. In the Deign view of Sequence Number it states "Event Procedure".


I'm either doing the export/import wrong or it's simply not working.
My first question is: Can the data of SDB1.mdb be transferred to a mdb database that has forms associated with it? I WANT TO MAINTAIN THE FORMS AND QUERIES OF RDB2. In others words, the only thing I want from SDB1.mdb is the data.
If it can, can you please explain how to get it working?
__________________
Thanks,
Sam

 

[The_Doc_Man]

You can open a direct import dialog from your destination database, point it to your source database rather than an intermediate holder file, and select the items you want to import. The dialog box is essentially a check-list of things you will import when you finally click OK. If you don't want to import anything but the tables, just check the tables and leave everything else unchecked.

P.S. ALWAYS ALWAYS ALWAYS make a backup copy of the destination database before you muck about in it wholesale like this.

 

[SamCec]

You can open a direct import dialog from your destination database, point it to your source database rather than an intermediate holder file, and select the items you want to import. The dialog box is essentially a check-list of things you will import when you finally click OK. If you don't want to import anything but the tables, just check the tables and leave everything else unchecked.

P.S. ALWAYS ALWAYS ALWAYS make a backup copy of the destination database before you muck about in it wholesale like this.

Doc Man:via your input I traced down my problem. After importing the data and description from SDB1.mdb into RDB2.mdb, I forgot to change the Table Name.

So thank you for your reply.

I do have another question concerning this:
The original database of RDB2.mdb used a SEQuence field (automtic numbering from 1 to n). SDB1.mdb, did not have a SEQ number field. I added a column to SDB1.mdb table and called it SEQ. Is there any way to have the records automatically sequenced or do I need to manually enter a sequence number for all existing records.