SQL Server Performance

automated procedure to import data

Discussion in 'SQL Server 2005 General Developer Questions' started by yukon_dba, Dec 7, 2007.

  1. yukon_dba New Member

    Hi all,
    I have to create a automated package. Firstly i have to import 2 specific columns from a excel file to create table1 in a database. then i have table2 with 20 columns out which i need only 3 columns. so its goes like this , i want to merge table1( 2 columns) with table 2 ( 3 specific columns) to create a new 3rd table with 5 columns. I want all these to automated.Here below is what my manager ask me to do for more clarification.The plan should be: Automated Import of Excel file to a table.Automated code as stored procedure which will compare another table to this imported tableOutput results of the table are 5 columns.
    Eventually the code and automated import process will be implemented in a database.
    Please i would appreciate if anyone can guide me to make this package .Thank u allYukon DBA
  2. yukon_dba New Member

    I am working on sql server 2000....
    thanks
    YUKON DBA
  3. ranjitjain New Member

Share This Page