Advanced Vision 3 Searches in Microsoft Excel by TailorMade I.T. Solutions

What's New... Welcome Home Page Latest Work Schedule Vision Services

Useful Programs Vision Support

Searches Support

Hotkeys for Vision General Tips & Advice INPS Official Site

INPS Training Services
is accredited with

NVUG Official Site DXS HealthCare Info

Secure Area

Join.Me Screen Sharing LogMeIn Secure Access A little bit of history! Software Support

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 :

...open a Vision single DBF export file in Excel (html)
...merge two DBF export files from Vision in Excel (html)
...merge patient addresses into Excel using DBF export - (Video)
...merge patient addresses into Excel using Tab Separated export - (Video)
...set up Microsoft Excel 2003 to Import Vision Data - (html)
...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)
...use the Vision Filer - (Video)

Other Useful Information

Take a look at our Excel Tips section