Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking and importing databases
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking and importing databases
Resolved · Low Priority · Version 2003
Reply Thu 10 Apr 2008, 15:55Delegate Alexandra said...
Alexandra has attended:
Access Introduction course
Linking and importing databases
Step by step to linking and importing database objects, especially where files have been moved from their original location.
For upcoming training course dates see: Pricing & availability
RE: Linking and importing databases
Hello Alexandra,
Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Linking and importing databases.
IMPORTING OBJECTS
Open a database, or switch to the Database window for the open database.
Do one of the following:
To import tables, on the File menu, point to Get External Data, and then click Import.
To link tables, on the File menu, point to Get External Data, and then click Link Tables.
In the Import (or Link) dialog box, in the Files of type box, make sure that Microsoft Access (*.mdb; *.adp; *.mda; *.mde; *.ade) is selected.
Click the arrow to the right of the Look in box, select the drive and folder where the Access file that you want to import or link is located, and then double-click the database's icon.
In the Import Objects (or Link Tables) dialog box, click each table that you want to import or link.
LINKED TABLES THAT HAVE MOVED
Use this procedure to view or to refresh links when the structure or location of a linked table has changed. The Linked Table Manager lists the paths to all currently linked tables.
1.Open the database that contains links to tables.
2.On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
3. Select the check box for the tables whose links you want to refresh.
4. Click OK to refresh the links.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
|