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 » Access
Access
Resolved · Low Priority · Version 2003
Tue 25 Nov 2008, 16:34Delegate Tsuruko said...
Tsuruko has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Access
How to link with Excel files.
Tue 25 Nov 2008, 17:15Trainer Simon said...
RE: Access
Hi Tsuruko,
Thank you for your question.
If you want to send data from Access to Excel, select the table or query by clicking once on it and go to Tools, Office Links and Analyse data with Excel.
If you want to import data from Excel into an Access table, you need to go to File - Get External Data - Import... Select the Excel file you want and then follow the steps of the wizard.
I hope this answers your question.
Regards
Simon
Training information:
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:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
