automated procedure to import data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

automated procedure to import data

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
I am working on sql server 2000….

Locking this thread as originator has created same thread under right category in below link.
Please continue the discussion here


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |