Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Importing from Magic to Access (any)

    Does anyone know of a tool or utility that will export the full set of tables from a Magic database (one version before the current) to access or anything else useful?
    Thanks

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Importing from Magic to Access (any)

    What in the world is a "Magic" database? One created by a Wizard? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> I don't know what export utilities are available in "Magic" but in all likelihood you will have to export the Magic tables to a generic format like CSV or fixed width text, then import into Access or other program like Excel. If "Magic" is ODBC compliant then you can create ODBC DSN for the Magic tables using Windows ODBC Data Source Adminstrator and then import into Access via ODBC.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from Magic to Access (any)

    magic is a database program developed in Israel see www.magic.co.il
    It is actually quite robust and fast for developing in.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from Magic to Access (any)

    It doesn't matter what it is. Unless it is ODBC compliant or uses a known file format like dBase or is capable of export data to Access, you're going to have to follow Mark's suggestion.
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Importing from Magic to Access (any)

    Taking a quick look at web site (out of curiosity) there are some 3rd party tools for Magic listed including something called mgExport. According to site: "mgExport is designed for exporting data tables to 10 formats (incl. HTML, Microsoft Word & Excel). It can export data to screen or file even if target application is not installed. It displays progress and it is very fast." Don't know if it supports export to Access but you can check it out, supposedly it's freeware.

  6. #6
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from Magic to Access (any)

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •