Wednesday, 12 March 2014

Import Data from EXCEL

How to Import Data from EXCEL to Destination
Import data from excel through wizard 
Step 1: Choose your database where to import data -->Tasks-->Import Data
Step 2: Click Next
Step 3: Choose the Data source as a Microsoft Excel and browse the file path as well as choose the Excel Version click next
Here we have the options to get the columns Dynamically (like First row has column names) or Manually we have to provide
Step 4:Now choose our destination and Authentication type also database -->click Next
Step 5: Choose either option click next
Step 6: Select the sheet where you have a required data then click next
Step 7:Here we have the options to choose either Package or run immediately 
Run immediately is a process which retrieves the data instantly 
If it is a package we can run package along with configuration file at any environment 
Step 8: Close 

3 comments:

  1. ӏ've been browѕing online more than three hourѕ today,
    yet I neveг found aոy interesting artіcle like yours.

    It's prettу worth enough for me. In my view,
    if all webmasters and bloggers made gooԀ
    content as ʏou did, the weeƅ will bе a loot more usefսhl thɑn
    ever before.

    Check oսt my weblog acheter maillot de foot

    ReplyDelete
  2. Thanks for your comment,I always try to help the people like this way
    Thanks again to the person who commented on it

    ReplyDelete
  3. thqs suresh it's usefull to me also.....

    ReplyDelete

EMP, DEPT Sample script

/****** Object:  Table [dbo].[DEPT]    Script Date: 19-05-2016 06:58:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET A...