Getting started with Access tutorial 18.2 how to link external data

Let's first open an Access database. Getting Started tutorial 18.2 how to link external data

Let's first open an Access Data Warehouse. Getting Started tutorial 18.2 how to link external data "/> click get external data items on the File menu, and click the 'Chain table' command on its sub-menu. A dialog box is displayed, similar to a dialog box for opening a file in Access. Getting started tutorial 18.2 how to link external data "/> WE

Open an AccessDataLibrary,

Getting startedTutorial18.2HowLinkExternalData"/>

Click "get" on the "file" menuExternalData", And click the 'linked table' command on its sub-menu. A dialog box is displayed, similar to a dialog box for opening a file in Access.

Getting startedTutorial18.2HowLinkExternalData"/>

We now import a DBASEDataLibrary file. First, move the mouse to the "file type" drop-down box and click the left mouse button to bring up a drop-down list.

Getting startedTutorial18.2HowLinkExternalData"/>

The methods for linking these file types are basically the same. You only need to select the correspondingDataLibrary type, and selectDataLibrary file to complete the link.

Getting startedTutorial18.2HowLinkExternalData"/>

For example, now I wantDataLibrary File "UserDataLibrary. The table in dbf is linked to Access. You only need to select "DBASE 5" in the file type drop-down box, select the directory of the file in the "search range" drop-down box, and select "UserDataLibrary. DBF "item, double-click,

A prompt box will pop up soon, telling us that this link operation has been successful, click "OK.

Go back to the "Link" dialog box and close the import dialog box.DataThe "existing Object List" in the table object in the library window already has a user nameDataDatabase.

Getting startedTutorial18.2HowLinkExternalData"/>

Open this table and checkDataAnd the original DBASE 5DataTableDataIs consistent. In this way, you can easily update the original system without worrying about it.DataConversion Problems.