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.
| Author |
Topic |
|
kets786
Starting Member
2 Posts |
 Posted - 2008-02-07 : 07:49:35
|
| Hi, I am new to SQL server and I need to import an excel spreadsheet into sql server. I have read the guide in the FAQ section of this forum but I have never used a DTS package? Could someone please guide me how I go about doing this. I am using SQL Server Enterprise Manager.ThanksKet |
|
|
kets786
Starting Member
2 Posts |
Posted - 2008-02-07 : 08:01:57
|
| I would also like to know that if I am importing an excel file into mysql server, do I have to create a table with all the matching fields in mysql server first?Thanks |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-07 : 10:43:01
|
| Hi, the steps areTake Enterprise manager, connecrt to db. Open new dts packageAdd a Excel file connection from left pane. Edit the properties to point to your local copy of file and also other properties like row/column delimiter. Preview the data in the excel by ciclikng preview button.Once this is done, Add a Server connection to package from left pane. Point connection your server,db. Then click tasks ->transform data task from top menu.Immediately the cursor changes to 'choose source conection'. Click on excel connection added earlier. Then click on Server connection to complete transform data task. Now an arrow connects both the connections.Double click on arrow and view properties. it will take sheet info by default. go to destination tab and click create button and sql window opens with create table sript for table with columns same as in excel (default name is Sheet1 you may change it to something more obvious). click on and goto mappings tab and see if all columns are mapped correctly (by default it will map. Then save the package and execute it. Check the table to see the populated rows. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-07 : 10:51:38
|
| If it's a on-off , you can just use the standard Import Data wizardJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 22:02:24
|
| In fact you can save package created by the wizard. |
|
|
|
|
|
|
Newbie, How can I import an excel file to sql serv