| Author |
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.
>
| |
| Adam Turner 2006-11-30, 7:14 pm |
| 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:
>
|
|
|
|