Name multiple sheets in excel export?

I have a report that when exported to Excel creates multiple sheets. Im
doing this on purpose. I wanted know if anyone new a way to
automatically name the Sheets in the Excel export? I wanted to name
them from a field on the report.I don't believe this is possible in the current versions of Reporting
Services. It seems like a functionality that would have a great deal
of value for reporting purposes, so hopefully MS will include this
feature in a future service pack.
pichula wrote:
> I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.|||I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
2000 (tried to find info about it myself a while ago), and I don't think you
can do it in RS 2005 either.
A pity, really, as it would be very usefull!
Kaisa M. Lindahl Lervik
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>|||Thanks for your replies. If this is not possible in RS 2005, does
anybody know about any workaround to this problem? Maybe using Excel
macros, etc.
elPablo
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
> 2000 (tried to find info about it myself a while ago), and I don't think you
> can do it in RS 2005 either.
> A pity, really, as it would be very usefull!
> Kaisa M. Lindahl Lervik
>
> "pichula" <kansas4451@.yahoo.com> wrote in message
> news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
> >I have a report that when exported to Excel creates multiple sheets. Im
> > doing this on purpose. I wanted know if anyone new a way to
> > automatically name the Sheets in the Excel export? I wanted to name
> > them from a field on the report.
> >|||Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?
=-Chris
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>

Naive Question on Export Data

Hi All,
When data is exported, to another database, the primary keys are not
available in the exported tables. Is there a way to export the data in the
tables along with all the properties of the table, I mean creating a ditto
copy of the original table along with data.
Thanks
kd
If you want a replica of the database, I suggest you use backup and restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:948F9BFC-7F18-4BFA-9572-F516066E539F@.microsoft.com...
> Hi All,
> When data is exported, to another database, the primary keys are not
> available in the exported tables. Is there a way to export the data in the
> tables along with all the properties of the table, I mean creating a ditto
> copy of the original table along with data.
> Thanks
> kd
>

mySQL -> msSQL

Hello all,

I spent the last two days trying to find an application that can export a mySQL database into msSQL syntax so that I can then use that to just create my msSQL database. I have had no such luck, though I could find a bunch to do msSQL to mySQL.

Please let me know if anyone has one or knows of one that works because I really do not want to hand port my 70 table database from mySQL to msSQL

Thanks in advance,

Anthony F Greco

DO you want application tool?

i found these two sites, not sure if it helps

http://www.softplatz.com/Soft/Network-Internet/Other/MySQL-MS-SQL-Server-Import-Export-Convert-Software.html

http://mysql-to-sql-server.qarchive.org/

|||Yes I did see them, I was just hopping to find a freeware one. If not I will go with one of them though. Thanks for the help =]|||

Hey

You could take a look at this:

Migrating MySQL to Microsoft SQL Server

I've done this before and just want to remind you that MySql is case sensitive but Sql server is not ,for example:

You hava column A(pk) B with values:

valueA valueB

valuea valueb

Sql Server will complain about violation ofprimary key constraint .

Hope this helps.