Exporting Datas to Excel File

I have a server where I have installed SQL Server.I am running a Visual
Basic Software in a Client computer.I want to execute a Sql Query which
exports all the datas of a sql server table to that client machine as a
MS-Excel file.I have done that query with MS-Access, but that's not
working with SQL Server.
Please reply meHi
The best way would be to use DTS for this if you are using SQL 2000 or SSIS
if you are using SQL 2005. You can use the Import/Export Wizard to create a
package and job that will do it for you if you don't want to start from
scratch. There is plenty of information on DTS/SSIS in books online, but
there are also additional information at http://www.sqldts.com
John
"retheeshnewage@.gmail.com" wrote:

> I have a server where I have installed SQL Server.I am running a Visual
> Basic Software in a Client computer.I want to execute a Sql Query which
> exports all the datas of a sql server table to that client machine as a
> MS-Excel file.I have done that query with MS-Access, but that's not
> working with SQL Server.
> Please reply me
>

Exporting Datas to Excel File

I have a server where I have installed SQL Server.I am running a Visual
Basic Software in a Client computer.I want to execute a Sql Query which
exports all the datas of a sql server table to that client machine as a
MS-Excel file.I have done that query with MS-Access, but that's not
working with SQL Server.
Please reply me
Hi
The best way would be to use DTS for this if you are using SQL 2000 or SSIS
if you are using SQL 2005. You can use the Import/Export Wizard to create a
package and job that will do it for you if you don't want to start from
scratch. There is plenty of information on DTS/SSIS in books online, but
there are also additional information at http://www.sqldts.com
John
"retheeshnewage@.gmail.com" wrote:

> I have a server where I have installed SQL Server.I am running a Visual
> Basic Software in a Client computer.I want to execute a Sql Query which
> exports all the datas of a sql server table to that client machine as a
> MS-Excel file.I have done that query with MS-Access, but that's not
> working with SQL Server.
> Please reply me
>

Exporting data from Excel to SQL DATABASE

Hi,
Is it possible to export data from Excel spreadsheet to different tables in
SQL SERVER DATABASE using XML? & how? I have Excel 2003 on my computer. I
need to do this every time the user , say clicks a button on the Excel sheet
.
Thanks for any help.
--
pmudYou probably want to ask this in the Office/Excel newsgroup regarding
specific functionality in Excel. You can obviously export the XML and then
using any of the XML import functionality of SQL Server 2000 such as the
SQLXML XML Bulkload object or OpenXML in T-SQL...
Best regards
Michael
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:231C0050-33FD-4487-B7BD-24FC870E86B1@.microsoft.com...
> Hi,
> Is it possible to export data from Excel spreadsheet to different tables
> in
> SQL SERVER DATABASE using XML? & how? I have Excel 2003 on my computer. I
> need to do this every time the user , say clicks a button on the Excel
> sheet.
> Thanks for any help.
> --
> pmud|||Hi Michael,
As you said that I can export XML & then using XML import functionality fo
sql server 2000 , I can export data from excel to SQL database. But do I hav
e
to do this process everytime a spreadsheet comes in ? or this can be coded
somewhere so that the process is automatically taken care of?
Is there any walkthrough or aticle which I can read.. Thanks..
"Michael Rys [MSFT]" wrote:

> You probably want to ask this in the Office/Excel newsgroup regarding
> specific functionality in Excel. You can obviously export the XML and then
> using any of the XML import functionality of SQL Server 2000 such as the
> SQLXML XML Bulkload object or OpenXML in T-SQL...
> Best regards
> Michael
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:231C0050-33FD-4487-B7BD-24FC870E86B1@.microsoft.com...
>
>|||I would assume that you could use scripting to do it, but I am not a
scripting expert and I think checking with the Excel experts would be a good
idea.
Best regards
Michael
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:908D5EA2-E452-4165-8B35-43FFBC1EEA23@.microsoft.com...
> Hi Michael,
> As you said that I can export XML & then using XML import functionality fo
> sql server 2000 , I can export data from excel to SQL database. But do I
> have
> to do this process everytime a spreadsheet comes in ? or this can be coded
> somewhere so that the process is automatically taken care of?
> Is there any walkthrough or aticle which I can read.. Thanks..
> "Michael Rys [MSFT]" wrote:
>|||Hi Michael,
Leaving the scripting apart, how can I export data from excel to XML only'
Is there some walkthrough or article that shows this?
Thanks a lot.
"Michael Rys [MSFT]" wrote:

> I would assume that you could use scripting to do it, but I am not a
> scripting expert and I think checking with the Excel experts would be a go
od
> idea.
> Best regards
> Michael
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:908D5EA2-E452-4165-8B35-43FFBC1EEA23@.microsoft.com...
>
>|||See under save as... There should be some XML options (at least in Excel
2003).
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:947DAF2A-D2EB-4D7A-989E-E4EBABF0ED33@.microsoft.com...
> Hi Michael,
> Leaving the scripting apart, how can I export data from excel to XML
> only'
> Is there some walkthrough or article that shows this?
> Thanks a lot.
> "Michael Rys [MSFT]" wrote:
>

Exporting data from Excel to SQL DATABASE

Hi,
Is it possible to export data from Excel spreadsheet to different tables in
SQL SERVER DATABASE using XML? & how? I have Excel 2003 on my computer. I
need to do this every time the user , say clicks a button on the Excel sheet.
Thanks for any help.
pmud
You probably want to ask this in the Office/Excel newsgroup regarding
specific functionality in Excel. You can obviously export the XML and then
using any of the XML import functionality of SQL Server 2000 such as the
SQLXML XML Bulkload object or OpenXML in T-SQL...
Best regards
Michael
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:231C0050-33FD-4487-B7BD-24FC870E86B1@.microsoft.com...
> Hi,
> Is it possible to export data from Excel spreadsheet to different tables
> in
> SQL SERVER DATABASE using XML? & how? I have Excel 2003 on my computer. I
> need to do this every time the user , say clicks a button on the Excel
> sheet.
> Thanks for any help.
> --
> pmud
|||Hi Michael,
As you said that I can export XML & then using XML import functionality fo
sql server 2000 , I can export data from excel to SQL database. But do I have
to do this process everytime a spreadsheet comes in ? or this can be coded
somewhere so that the process is automatically taken care of?
Is there any walkthrough or aticle which I can read.. Thanks..
"Michael Rys [MSFT]" wrote:

> You probably want to ask this in the Office/Excel newsgroup regarding
> specific functionality in Excel. You can obviously export the XML and then
> using any of the XML import functionality of SQL Server 2000 such as the
> SQLXML XML Bulkload object or OpenXML in T-SQL...
> Best regards
> Michael
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:231C0050-33FD-4487-B7BD-24FC870E86B1@.microsoft.com...
>
>
|||I would assume that you could use scripting to do it, but I am not a
scripting expert and I think checking with the Excel experts would be a good
idea.
Best regards
Michael
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:908D5EA2-E452-4165-8B35-43FFBC1EEA23@.microsoft.com...[vbcol=seagreen]
> Hi Michael,
> As you said that I can export XML & then using XML import functionality fo
> sql server 2000 , I can export data from excel to SQL database. But do I
> have
> to do this process everytime a spreadsheet comes in ? or this can be coded
> somewhere so that the process is automatically taken care of?
> Is there any walkthrough or aticle which I can read.. Thanks..
> "Michael Rys [MSFT]" wrote:
|||Hi Michael,
Leaving the scripting apart, how can I export data from excel to XML only?
Is there some walkthrough or article that shows this?
Thanks a lot.
"Michael Rys [MSFT]" wrote:

> I would assume that you could use scripting to do it, but I am not a
> scripting expert and I think checking with the Excel experts would be a good
> idea.
> Best regards
> Michael
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:908D5EA2-E452-4165-8B35-43FFBC1EEA23@.microsoft.com...
>
>
|||See under save as... There should be some XML options (at least in Excel
2003).
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:947DAF2A-D2EB-4D7A-989E-E4EBABF0ED33@.microsoft.com...[vbcol=seagreen]
> Hi Michael,
> Leaving the scripting apart, how can I export data from excel to XML
> only?
> Is there some walkthrough or article that shows this?
> Thanks a lot.
> "Michael Rys [MSFT]" wrote:

Exporting a database

Hey guys another dumb question for you :)

How would I export the database on my computer to a file that I can stick on CD/floppy to use on another computer? Also what file format should I export it as?
Thanks for you help guys!

My final project is almost done and all I have left to do is tweak the SQL ERD a bit and impliment it into Visual Basic (thats gonna be fun figureing that out)

Thanks in advance!Ever heard of database backups !!!

Or for that sake detaching, attatching databases.

Look up the Holy Book (SQL Server Books online) for these thingssql

export/import registered server list from/to EM

how can I export the list of servers I've registered in my enterprise manager
and import it back on other computer's EM? TIA.
Adi ..See if this helps:
http://groups-beta.google.com/group/microsoft.public.sqlserver.tools/msg/53d641423f7828bb?hl=en
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"adi" <adi@.discussions.microsoft.com> wrote in message
news:40E5E439-F0F8-425E-B7A5-41D72A08E070@.microsoft.com...
how can I export the list of servers I've registered in my enterprise
manager
and import it back on other computer's EM? TIA.
Adi ..|||Thanks Vyas,
That was helpful. That script imported all servers under default "SQL Server
Group", but it was better than nothing.
"Narayana Vyas Kondreddi" wrote:
> See if this helps:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.tools/msg/53d641423f7828bb?hl=en
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:40E5E439-F0F8-425E-B7A5-41D72A08E070@.microsoft.com...
> how can I export the list of servers I've registered in my enterprise
> manager
> and import it back on other computer's EM? TIA.
> Adi ..
>
>

export/import registered server list from/to EM

how can I export the list of servers I've registered in my enterprise manage
r
and import it back on other computer's EM? TIA.
Adi ..See if this helps:
f7828bb?hl=en" target="_blank">http://groups-beta.google.com/group...
f7828bb?hl=en
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"adi" <adi@.discussions.microsoft.com> wrote in message
news:40E5E439-F0F8-425E-B7A5-41D72A08E070@.microsoft.com...
how can I export the list of servers I've registered in my enterprise
manager
and import it back on other computer's EM? TIA.
Adi ..|||Thanks Vyas,
That was helpful. That script imported all servers under default "SQL Server
Group", but it was better than nothing.
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> 23f7828bb?hl=en" target="_blank">http://groups-beta.google.com/group...23f7828bb?hl=en
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:40E5E439-F0F8-425E-B7A5-41D72A08E070@.microsoft.com...
> how can I export the list of servers I've registered in my enterprise
> manager
> and import it back on other computer's EM? TIA.
> Adi ..
>
>