Microsoft Office Tutorials and References
In Depth Information
Importing or Linking to Data
3. Click the Browse button to navigate to your data file.
Navigate through the folders, if necessary, to find the file that contains
the data you want to use, and click the filename so that it appears in the
File Name box.
If you’re linking, and the file that you’re linking to is on a local area
network or another remote computer, use the universal naming convention
(UNC) path for the file rather than a drive letter that’s mapped. The UNC
path is a more reliable way for Access to locate the data. A UNC path
looks like the following:
\\ server directory file \
You have to know the server name to type the UNC.
4. Choose how you want to store the data in the current database.
You can import the data into a new table in the current database,
append the data to an existing table (all the fields must correspond
exactly for this option to work), or link to the data outside Access. The
advantages and disadvantages of each of these options are discussed in
5. Click OK.
Depending on the type of file you’re working with, you may see a wizard
that guides you through the process of choosing the data you want to
import or link to.
The windows you see depend on the type of file that contains the data
you’re importing or linking to. (The following sections guide you through
the text and spreadsheet wizards.) Some data types import immediately,
ready for use.