98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Linking to excel
Linking to excel
Resolved · Medium Priority · Version 2007
Bethan has attended:
Access Introduction course
Linking to excel
does the link to excel from access exist automatically (is there any issue around security and firewalls)
RE: linking to excel
Dear Bethan
Thank you for attending Access 2007 course. I hope you enjoyed the course and benefited from it.
As far as I am aware there shouldn't be any issues whatsoever. However if your Excel file has macros and you try to import it in access It will come up with some security warning. If you trust the source of the data then you can simply click on the security warning and choose enable this content.
You will have to consult your technical dept if you get any specific blocking while importing and exporting as it may be certain firewalls or anti virus programs that may be causing the errors.
I hope this answers your query.
Please mark this post as resolved if this has helped in answering your specific query!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
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:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |