excel

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips


Server loaded in 0.08 secs.