Friday, February 10, 2012

cli for MSSQL server?

I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
quote:

>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->

Run
quote:

>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>
|||Then consider installing SQL Server client utilities on this machine.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
quote:

>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->

Run
quote:

>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>

No comments:

Post a Comment