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 » Linking Excel to Access
Linking Excel to Access
Resolved · Low Priority · Version 2007
Mon 23 Aug 2010, 16:12Delegate Deborah said...
Deborah has attended:
Access Intermediate course
Access Introduction course
Excel Advanced course
Excel Intermediate course
Excel Advanced course
Linking Excel to Access
Is there any value to linking an entire workbook vs a single spreadsheet?
Tue 24 Aug 2010, 18:20Trainer Anthony said...
RE: Linking Excel to Access
Hi Deborah, thanks for your query. Depends what you've got in the workbook really. Remember that Access chops up each worksheet in the workbook into a separate table in Access, so you'd have to go through the Link Tables process for each worksheet in the workbook to link the whole thing into Access.
Hope this helps,
Anthony
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:Label printingYou can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps |
