Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Excel Import

Author  Topic 

Pavithra subbareddy
Starting Member

1 Post

Posted - 2014-07-15 : 08:42:09
Hi Friends,
I wanna to import excel from local to DB table.

Excel will be in one server and DB will in another server.this import should be schduled.

How to achieve this.My friend suggest to use SSIS.how to use SSIS for this.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-15 : 09:42:11
Assuming a basic knowledge of SSIS:

1. Add an Excel Source datasource to your dataflow
2. connect it to an OLE DB destination
3. run it

If you don't know SSIS, you can use the wizard in SSMS (Right-click on the target database, select Tasks... then Import Data)
Go to Top of Page
   

- Advertisement -