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

advanced microsoft access training london - importing excel table into

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access training london - Importing excel table into access

advanced microsoft access training london - Importing excel table into access

ResolvedVersion Standard

Teresa has attended:
No courses

Importing excel table into access

i have created a new access table by importing columns from an existing excel table - this is being updated on a daily basis - is it possible to refresh the data in my access table automatically so that each time new items are input into the excel spreadsheet they will be updated in my access table?

thanks

RE: importing excel table into access

Create a LINK to excel by going to FILE then GET EXTERNAL DATA the LINK TABLES

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

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.1 secs.