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

excel

ResolvedVersion Standard

Neena has attended:
Excel Intermediate course

Excel

Can I import data from ACCESS?

RE: Excel

Hi Neena, Thank you for the post, Welcome to the forum, In answer to your question, a big Yes!, to do this you will need to use the Data>Import External Data menu command, choose the option New Database Query and from the Choose Data Source dialog box choose MS Access Database; Click OK, navigate to your access file, when you have your file in the left hand window, select it click to proceed and from the Choose Columns dialog box select the table you wish to use, Click Next, you can filter un-required fields at this point, click Next to sort and Next again, choose the first option in the next box and click Finish, your table from Access will be inserted in the location you direct. I hope that helps, best regards Pete.

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.