Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Post Unanswered: how to import data from excel file to sqlserver database

    how to import data from excel file to sql server database....if any one know .......plz let me know

  2. #2
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    Code:
    SELECT * INTO TABLE_NAME
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=d:\TABLE_NAME.xls', 'SELECT * FROM [Sheet1$]')
    hope this will help u
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

  3. #3
    Join Date
    Sep 2010
    Posts
    153
    without tool or with the help of a tool or help of inbuilt features like SSIS which comes with sql server licensed version?

Posting Permissions

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