Home ›
ASP.NET Forums » Data Access » MySQL » import Excel into MSSQL

import Excel into MSSQL

Last post 05-11-2008 5:15 AM by 101jonny. 2 replies.

Sort Posts:

  • import Excel into MSSQL

    05-11-2008, 4:54 AM
    • Loading...
    • 101jonny
    • Joined on 05-11-2008, 3:54 AM
    • Minnesota
    • Posts 104

    I have excel files with data I would like on my MySQL server anyone have any tips

    Thanks Jonny

  • Re: import Excel into MSSQL

    05-11-2008, 5:12 AM
    Answer
    • Loading...
    • haoest
    • Joined on 10-25-2005, 8:20 PM
    • Posts 401

    You can use Data Transformation Services (DTS) if you have sql2000. If you have 2005, you can right click on your database in sql server management studio and go to Import. You'll be able to import data to your db

                 
     

    Debugger is my best friend. (http://haoest.info)

  • Re: import Excel into MSSQL

    05-11-2008, 5:15 AM
    • Loading...
    • 101jonny
    • Joined on 05-11-2008, 3:54 AM
    • Minnesota
    • Posts 104

    even with express edition

     
Page 1 of 1 (3 items)
RSS Available

Advertise on ASP.NET

About this Site

Microsoft Communities
Page view counter