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
No comments:
Post a Comment