locked
How to Import a Excel Datas to SQL Server Database RRS feed

  • Question

  • User299668802 posted
    How to Import a Excel Datas to SQL Server Database
    Friday, April 27, 2007 12:59 AM

Answers

  • User1531483524 posted

    Open Enterprise Manager and right click on the database name into which you want to import the data.

    Go to All Tasks > Import Data > Click Next on the DTS Import/Export Screen. On the Choose a Data Source screen select Microsoft Excel 97-2000 in the Data Source dropdown.

    Browse to the excel file (browse button beside the File Name text box) click next and Select the destination (the database in which you want to import data) click next on the next dialog keep 'Copy table(s) and view(s) from the source database' > click next select the worksheets that you want to import click next > On the next screen keep Run Immediately checked click Next and then Finish

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 27, 2007 3:43 AM