Microsoft Access provides a lot of ways for copying objects such as table or form from a database to another. Copying and pasting is yet the easiest way but exporting a certain object even offers you more options. For example, you can export up the table definition and data in table, or just export the table definition (the blank copy of table). You can also opt to save the details regarding the operation for future use. This discussion will explain the method to export an object using a wizard and finally how to save details of the operation performed.
The following steps are involved in this operation:
Step 1 – First of all we need to prepare for the export. To do so, we have to open the source database. The format of the file can be either ACCDB or MDB. If the file is in these formats, then the source object must be a query, a table, or it can be a macro. Apart from this you cannot export the forms, modules or the reports or even an ACCDE or MDE file.
Step 2 – Now we need to identify the object that we want to export. For this first we have to export the linked table. If the table that you are supposed to export is a linked table, then the export operation creates linked table in destination database. After this operation the new linked table gets links to original source table.
Step 3 – Further you have to open up the destination database. The format of file can be either ACCDB or MDB and it can also be an ACCDE or MDE file. So we have to make sure that it should not be a read-only file and if it is then you should have permissions to make alterations in it. One thing you have to keep in mind is that an object can exist with a same name as the source in your destination database, so you must decide whether if you want to overwrite the existing version of the object or specify it with a different name. Now you are ready to make execution for the export operation.
Step 4 – You need to run the export wizard and for this go onto External Data tab, then in Export group, click on more, and finally click on Access Database.
Step 5 – Once you have that in the File name box, specify the name of destination database and then hit OK.
Step 6 – In the Export dialog box, change the name of new object if you don’t want to overwrite on existing object with same name in destination database. If the object that you had selected is a table, then you have to specify whether you want to export the data and definition of table or only the definition.
Step 7 – After completing all the steps given above finally click on OK to finish the operation. This way you would be able to copy one field definition to the other.