Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking excel

ResolvedVersion 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

Access tip:

Label printing

You 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

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.