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