Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MUMPS file conversion

90 views
Skip to first unread message

Mad Professor

unread,
Jun 19, 1996, 3:00:00 AM6/19/96
to

I need to find a way to convert a MUMPS database file into a format
that can be used by MS-SQL Server or MS-Access. This particular
database is a custom job and apparently has no exporting functionality
whatsoever.

I know what I'm trying to do must be possible. Does anyone have any
suggestions on implementation, products, etc.? Any assistance is
greatly appreciated.

Frank Banks


Mark Lauteren

unread,
Jun 20, 1996, 3:00:00 AM6/20/96
to

MSM-SQL (Micronetics), KB_SQL (KB Systems), and M-SQL (InterSystems) all allow
you to 'map' existing M data bases into a relational structure. All three
products run on multiple M platforms. All three products allow you to then
(with the purchase of an additional server add on) to access the M data
through ODBC complient query tools (which MS-SQL and MS-Access both have).

Mark Lauteren
Laboratory Corporation of America

********************************************************************************
The opinions expressed by me are my own, and do not necessarily represent those
of my employer.
********************************************************************************

Syntax is a harsh mistress.

===============================================================================

>================== RFC 822 Headers ==================
>Return-Path: owner-...@uga.cc.uga.edu
>Received: by cowboy.biomed.com (UCX V3.2-9D);
> Wed, 19 Jun 1996 17:33:58 -0500
>Received: from uga.cc.uga.edu by firewall with SMTP
> (1.39.111.2/16.2) id AA163573860; Wed, 19 Jun 1996 18:37:40 -0400
>Received: from UGA.CC.UGA.EDU by uga.cc.uga.edu (IBM VM SMTP V2R3)
> with BSMTP id 0515; Wed, 19 Jun 96 18:34:56 EDT
>Received: from UGA.CC.UGA.EDU (NJE origin LISTSERV@UGA) by UGA.CC.UGA.EDU
(LMail V1.2a/1.8a) with BSMTP id 5216; Wed, 19 Jun 1996 18:34:27 -0400
>Date: Wed, 19 Jun 1996 12:48:44 GMT
>Reply-To: f...@intraversal.com
>Sender: MUMPS List <MUM...@UGA.CC.UGA.EDU>
>From: Mad Professor <f...@INTRAVERSAL.COM>
>Organization: CU-Online "Your one stop Internet Provider!"
>Subject: MUMPS file conversion
>To: Multiple recipients of list MUMPS-L <MUM...@UGA.CC.UGA.EDU>

Antonio Gino

unread,
Jun 20, 1996, 3:00:00 AM6/20/96
to

I have converted M databases to MS Access. It is a simple matter to
write an M routine that will transfer the data to an ASCII file, with
appropriate field delimiters (e.g., {Tab}). You can then tell MS
Access to import the data from the ASCII file.
0 new messages