98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version Standard
Thu 3 May 2007, 17:01Delegate Teresa said...
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
Fri 4 May 2007, 14:18Trainer Garry said...
RE: importing excel table into access
Create a LINK to excel by going to FILE then GET EXTERNAL DATA the LINK TABLES
Training information:
- Advanced microsoft access training london
- Courses in microsoft access
- Microsoft Access Training London
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Action queriesUnlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read. |
