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 |
|
madiha
Starting Member
2 Posts |
 Posted - 2014-10-21 : 07:04:01
|
| Hi i am new to sql and i would like to do following task. i would like to update my database in sql with the records from excel sheet.there are 9 columns each and each 3 columns are from one table. so 1 row will send data to three different tables.can you please suggest me and help me to achieve this task in excel. i dont have any knowledge for using macros or eventsthank in advance |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-10-21 : 07:44:07
|
| you can use SSIS to achieve thisJaveed Ahmed |
 |
|
|
madiha
Starting Member
2 Posts |
Posted - 2014-10-22 : 12:19:41
|
quote:
Originally posted by ahmeds08
you can use SSIS to achieve thisJaveed Ahmed
well Javeed actually i want it to be used as front end.....everything to be done from excel |
|
|
|
|
|
|
How to transfer data from excel to ms sql 2005