Load data from excel to sql server table

Hi,

I have data in a Excel spread sheet that has been saved as a csv file.
I need to load this data into a sql server table. What is the best way
to do this. Any ideas?

Thanks in advance.

use DTS Wizard


vt

"db-x" <rashmi.ndeshpande@gmail.com> wrote in message
news:1164900614.237522.111940@l39g2000cwd.googlegroups.com...
> Hi,
>
> I have data in a Excel spread sheet that has been saved as a csv file.
> I need to load this data into a sql server table. What is the best way
> to do this. Any ideas?
>
> Thanks in advance.
>

Yes DTS or SSIS would be the best choice.

"db-x" <rashmi.ndeshpande@gmail.com> wrote in message
news:1164900614.237522.111940@l39g2000cwd.googlegroups.com...
> Hi,
>
> I have data in a Excel spread sheet that has been saved as a csv file.
> I need to load this data into a sql server table. What is the best way
> to do this. Any ideas?
>
> Thanks in advance.
>

Thanks a lot.. that does seem to work.. but I need a script or a
program to do that.. what is the sql command that could be used ? I'm
new to DB.. sorry if I'm asking a dumb question :-)

vt  wrote:[color=darkred
]
> use DTS Wizard
>
>
> vt
>
> "db-x" <rashmi.ndeshpande@gmail.com> wrote in message
> news:1164900614.237522.111940@l39g2000cwd.googlegroups.com... 

check

OPENDATASOURCE  function

vt


"db-x" <rashmi.ndeshpande@gmail.com> wrote in message
news:1164903796.447484.26940@f1g2000cwa.googlegroups.com...
> Thanks a lot.. that does seem to work.. but I need a script or a
> program to do that.. what is the sql command that could be used ? I'm
> new to DB.. sorry if I'm asking a dumb question :-)
>
> vt wrote: 
>

or  you can use

OPENROWSET  function as well

vt




"db-x" <rashmi.ndeshpande@gmail.com> wrote in message
news:1164903796.447484.26940@f1g2000cwa.googlegroups.com...
> Thanks a lot.. that does seem to work.. but I need a script or a
> program to do that.. what is the sql command that could be used ? I'm
> new to DB.. sorry if I'm asking a dumb question :-)
>
> vt wrote: 
>