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 |
|
abs777
Starting Member
2 Posts |
 Posted - 2008-04-23 : 18:24:37
|
| I have an excel spreadsheet with data (column C) I need to import into an existing DB table (cur_customers). I have a field in the table (cust_name) that matches the spreadsheet (column B). So I need to import (column C) into (cust_phone) where (column B) = (cust_name).I have no idea how to this.Any help will be greatly appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 18:29:35
|
| Post in script library. Madhi will help you |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-23 : 18:31:25
|
| If you post a new thread into the script library, I will be forced to move it back to this one as non-working scripts do not belong in that forum. Sodeep, please provide more information on what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 18:32:48
|
| I mean include in Export to Excel |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-23 : 18:36:50
|
| Why don't you provide the link so that it is more clear?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-23 : 22:17:22
|
| >> I need to import (column C) into (cust_phone) where (column B) = (cust_name).Try set linked server to excel then load data with 'insert ... select ...'. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-28 : 08:59:37
|
quote:
Originally posted by abs777
I have an excel spreadsheet with data (column C) I need to import into an existing DB table (cur_customers). I have a field in the table (cust_name) that matches the spreadsheet (column B). So I need to import (column C) into (cust_phone) where (column B) = (cust_name).I have no idea how to this.Any help will be greatly appreciated.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926&whichpage=16#389175MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Help to import from Excel spreadsheet