Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    17

    Unanswered: data from mdf to excel

    Hello guys,
    I have an mdf file and I need to get the data
    from there to excel (not vice versa). Can I do that
    without installing ms sql server. I have heard that
    odbc sql drivers help but I don't know how.
    I'm a beginner in this area. Please help me.

    Best regards,
    Jessica

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I don't believe you can do this. If you attach the mdf file to a SQL Server you can easily do this with DTS.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Sep 2003
    Posts
    69
    If the MDF file is readable in another database tool you can export it to CSV then import it into excel... just one option

  4. #4
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    U must install SQL Server,and attach the database.Then using sql server's data import & export tools to do it.

  5. #5
    Join Date
    Sep 2003
    Posts
    17
    Thank you guys, it seems that I still have
    to install ms sql to do this.

    Jessica

  6. #6
    Join Date
    Sep 2010
    Posts
    1
    hi jessica i was wondering if you solved ur issue because i am facing the same. please let me know. thank you

Posting Permissions

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