Hey Irish, I was wondering where you had gotten to,
The trick here is to use the MS Access external data import routines to do the work for you. Steps: Create a delimited report in NPR and save it to your hard drive as .txt or .csv. Create new database in access Go to File|Get External Date|Import... You should now be at a file select popup box, change the "Files of Type:" setting from MS Access to Text files. Navigate to your file and click on it. The Import wizard screen will come up. The rest is intuitive. Gordon Dowling [EMAIL PROTECTED] Applications Analyst Huron Perth Healthcare Alliance Stratford, ON N5A 2Y6 (519) 272-8210 ext 2268 _____ From: Tumbleton, Keiron M. [mailto:[EMAIL PROTECTED] Sent: January 4, 2007 1:15 PM To: [email protected] Subject: [MEDITECH-L] Using Microsoft Access to pull demographic data fromMEDITECH (ADM/ABS) Hi, Has anyone ever undertaken/accomplished the task of pulling Demographic data (from say, ADM or ABS) into an MS Access database ? Is this even possible with interfaces or off the shelf software ? Thanks in advance. MAGIC 5.4 sr2 ------------------------------------------------------------------------ -- Keiron Tumbleton (617)-983-7897 [EMAIL PROTECTED] THE INFORMATION TRANSMITTED IN THIS ELECTRONIC COMMUNICATION IS INTENDED ONLY FOR THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY CONTAIN CONFIDENTIAL AND/OR PRIVILEGED MATERIAL. ANY REVIEW, RETRANSMISSION, DISSEMINATION OR OTHER USE OF OR TAKING OF ANY ACTION IN RELIANCE UPON, THIS INFORMATION BY PERSONS OR ENTITIES OTHER THAN THE INTENDED RECIPIENT IS PROHIBITED. IF YOU RECEIVED THIS INFORMATION IN ERROR, PLEASE CONTACT THE SENDER AND THE PRIVACY OFFICER, AND PROPERLY DISPOSE OF THIS INFORMATION.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
