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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-05-01 : 09:22:19
|
| HiI have an excel file that I would like to put into SQL so I can run queries on it. Is there any way I can create a procedure that will pull my info from my excel file to SQL? Any suggestions would be helpful.Thanks!Wendy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-01 : 09:36:59
|
| check out:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 |
 |
|
|
argus
Starting Member
2 Posts |
Posted - 2008-05-01 : 21:54:42
|
| If i am not wrong that link is for sending from sql to excel.Please can you help us in sending data from excel(csv) to sqlI am a beginner with sql.thanks in advance |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-02 : 02:34:15
|
| You can use many methods for doing this:-http://support.microsoft.com/kb/321686 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-05-02 : 05:39:23
|
quote:
Originally posted by argus
If i am not wrong that link is for sending from sql to excel.Please can you help us in sending data from excel(csv) to sqlI am a beginner with sql.thanks in advance
Read the link carefullyIt is for both import/export to excelMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Procedure to Transfer data from Excel to SQL