| Importing from another database |
| There are many ways to take data of a data base from Access to another one. The simplest method is to copy them and paste them, but importing and linking it, will allow you to have better control and provide greater flexibility respect to the data. |
| During the import operation, it is possible to chose the objects that are desired to copy, to control how the tables and the queries are moved, to specify the relations between tables, etc. |
| 1) Look for the data base of origin and identify the objects that wish to import. |
| 2) If the source data base is a mdb or accdb file, you can import tables, queries, forms, reports, macros and modules. |
| 3) If the source data base is a mdb or accdb file, only tables can be imported. |
| 4) Close the source database. Be sure no user has it open in exclusive way. |
| 5) Open the target data base. Be sure that the data base is not read only. |
| 6) Open TutorialDB. Select the Get External data tab and select the Access option. |
  |
| Illustration 1: Select the right import command. In this case, Access command. Click here to view larger image. |
| 7) Browse for the source database. |
 |
| Illustration 2: Select the source database. Click here to view larger image. |
| 8) If you want to import the data, select the Import tables option. |
| 9) If you want to link the source table selects the Link data source option. This option does not import the data. It permits to view and work with the data that remains stored at the source database. |
| 10) By the Import option, select the table Books to import and press the OK button. |
 |
| Illustration 3: Select the books table. |
| 11) You could save the previous steps for later use. To do this, select the Save Import steps and press the CLOSE button. |
 |
| Illustration 4: Save steps for later use. Click here to view larger image. |
| 12) As you can see, the books table has been imported from another access database. |
| 13) Delete the Books table. |
| 14) Open TutorialDB. Select the Get External data tab and select the Access option. |
| 15) Browse for the source database. |
| 16) Link the source table. Select the Link data source option. This option does not import the data. It permits to view and work with the data that remains stored at the source database. |
 |
| Illustration 5: Linking tables. Click here to view larger image. |
| 17) Select the Books table and press the OK button. |
 |
| Illustration 6: Linking tables. |
 |
| Illustration 7: Linking Book table. |
| An arrow at the left side of table name will indicate that this is a linked table |
| Import Data: appending in an existing table |
| 18) You could import some data from other sources into this table. To do this, create a new Areas table. |
 |
| Illustration 8: Create Areas table. Click here to view larger image. |
| 19) Click on the Areas table name at the left pane. Right click to display the context menu and select the Import menu item. |
 |
| Illustration 9: Data import menu. |
| 20) The Get external Data wizard will appear. Browse for the file to import and select the Append a copy of the records to the table option. Select the Areas table. |
 |
| Illustration 10: Get external data wizard. Click here to view larger image. |
| 21) Once selected the file and table, press the OK button. The wizard to configure the data import will appear. |
 |
| Illustration 11: Automatic field¡¯s delimiters screen. Click here to view larger image. |
| Our imported file is a semi colon separated values text file. Then, we live the Delimited option as is. |
| 22) If you need to configure more options, press the Advanced ¡ button. |
 |
| Illustration 12: Advanced field¡¯s delimiters screen. Click here to view larger image. |
| Here, you could set up the language collation, the code page, date and time options and the skipped fields (useful when you do not want to import the entire file). |
| 23) Press the Next button to select the field¡¯s delimiters. |
 |
| Illustration 13: Manual field¡¯s delimiters screen. Click here to view larger image. |
| As you can see in the above screen, a vertical line is indicating the field¡¯s separators. Once you confirm the correct delimiters press the Next button. |
| 24) The Import Text Wizard will resume the table destination and give you the opportunity to analyze the data after import. Press the Finish button. |
 |
| Illustration 14: Finishing the data import. Click here to view larger image. |
| 25) Mark the I would like to analize my table option after importing the data to see the results directly. Press the Finish button. |
 |
| Illustration 15: Press the Yes button. |
| See the imported data in the datasheet view. |
 |
| Illustration 16: Imported fields. |
| Export Data |
| You could export some data from Access databases to other formats. |
 |
| Illustration 17: Available format to export Access databases. |
| 26) Click on the Files table name at the left pane. Right click to display the context menu and select the Export menu item. |
 |
| Illustration 18: Export a table to Excel Data file. |
| 27) The Get external Data wizard will appear. Browse for the file to export and select the Export data with formatting and layout option. Press the OK button. |
 |
| Illustration 19: Export a table to Excel Data file. Click here to view larger image. |
| 28) See the excel file. |
 |
| Illustration 20: Excel file. Click here to view larger image. |
discuss this topic to forum
