Results 1 to 3 of 3

Thread: excel to mssql

  1. #1
    Join Date
    Oct 2003
    Location
    turkey, eregli
    Posts
    7

    Unanswered: excel to mssql

    Hi,
    is there any way to port excel data into mssql through mssql management studio express edition or by using excel itself.
    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Um.... T-SQL do ya?

    Code:
    Insert into MyTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
    'Excel 8.0;Database=D:\MyExcelWorkBook.xls;HDR=YES', 
    'SELECT * FROM [MyWorkSheet$]')
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2004
    Posts
    268
    Why don't you use DTS to import data from Excel to MSSQL?

Posting Permissions

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