Importing Vision data into Microsoft Excel requires two elements to of been performed per workstation; If you are on the INPS remote server (VES) the following is automatically installed and you may skip these steps:

• A Microsoft Visual FoxPro ODBC Driver needs to of been installed per workstation it is run on.
  Download and run : English VFPODBC.MSI

• Microsoft Query needs to of been installed which is part of the  Microsoft Office installation. If it hasn't been installed you will be prompted and may need the original CD to add this feature.

How do we :

• ...set up Microsoft Excel 2003 to Import Vision Data - (Document Download)
• ...set up Microsoft Excel 2007 to Import Vision Data - (Document Download)
• ...find our Records 9 count for QOF - (Document Download)
• ...automatically link medication to a problem - (Document Download)
• ...export a list of all childhood immunisations - (Video)
• ...find duplicate patients within Vision - (Video)
• ...send a letter to the Head of the Household - (Zip file)
• ...create a Generic Drug Search - Remote Server - (Document Download)
  • ...for Generic Rx Search (Remote Vision) - (Executable)
• ...create a Generic Drug Search - Practice Server - (Document Download)
  • ...for Generic Rx Search (Practice Server) - (Executable)
• ...Cross Reference Flu Appointments with Clinical data - (Document Download) Office 2003
• ...Cross Reference Flu Appointments with Clinical data - (Document Download) Office 2007
• ...find duplicate patient records - (Document Download)

Other Useful Information

Take a look at our Excel Tips section