Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel computer training - how do import database

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - How do i import database files

excel computer training - How do i import database files

ResolvedVersion Standard

Shaheeda has attended:
Excel Intermediate course

How do i import database files

see above

RE: how do i import database files

Hi Shaheeda,

Thanks for the question

To import a database file simply use the Data Menu, go down to Import External Data and across to New Database Query. From there you get a dialog box which you choose MS Access Database and follow the wizard to locate the table and fields you wish to bring in.

Hope that helps

Tracy

RE: how do i import database files

Thank you Tracy,

I have not recieved my Excel Intermiediate CD as yet:
Just to confirm my address again:

19 paignton road
riuslip manor
HA4 0BU


Best Regards
Shaheeda

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.