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 |
|
newbeetosql
Starting Member
2 Posts |
 Posted - 2008-12-23 : 09:52:17
|
| All,I am very new to Sql world and would like to get my feet wet.I want to email a .csv file to SQL and which should then run append that .csv to an existing table on the SQL.Please Help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 09:54:46
|
| Use Export/Import wizard. |
 |
|
|
newbeetosql
Starting Member
2 Posts |
Posted - 2008-12-23 : 10:01:45
|
| Can you please be more specific - something like a step by step procedure would help |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 10:09:16
|
| SQL Server comes with Books online.It is helpful resources for beginners. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-12-23 : 14:58:24
|
quote:
Originally posted by newbeetosql
Can you please be more specific - something like a step by step procedure would help
As sodeep suggested, use the import/export wizard. That will provide you with a step by step method of getting it set up. Very simple tool to use for something like this. Once done, you can save the package and fire it up off the scheduler if this will be a recurring job. And, as sodeep also suggested, BOL is a great resource that you should use with regularity. Even us old-timers can still find many things of value in it, always more to learn you know!  Post back if you get stuck, show us what you've done and we'll gladly point you in the right directon.Terry |
|
|
|
|
|
|
Email .csv file to sql