Mail Id-how to store?

Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam
Hi,
Use the data type VARCHAR. The maximum limit is 8000 characters. I recomment
you to have 120 bytes for email storage maximum.
Declare @.emailid varchar(120)
Tahnks
Hari
SQL Server MVP
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
> Hi,
> How to store email address in SQL Server and is there a special data type
> for it and whats the maximum limit that can be stored?
> Kindly help me.
> Regards,
> Shyam
|||See if this helps:
http://vyaskn.tripod.com/handling_em...sql_server.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam

Mail Id-how to store?

Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
ShyamHi,
Use the data type VARCHAR. The maximum limit is 8000 characters. I recomment
you to have 120 bytes for email storage maximum.
Declare @.emailid varchar(120)
Tahnks
Hari
SQL Server MVP
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
> Hi,
> How to store email address in SQL Server and is there a special data type
> for it and whats the maximum limit that can be stored?
> Kindly help me.
> Regards,
> Shyam|||See if this helps:
http://vyaskn.tripod.com/handling_e..._sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam

Mail Id-how to store?

Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
ShyamHi,
Use the data type VARCHAR. The maximum limit is 8000 characters. I recomment
you to have 120 bytes for email storage maximum.
Declare @.emailid varchar(120)
Tahnks
Hari
SQL Server MVP
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
> Hi,
> How to store email address in SQL Server and is there a special data type
> for it and whats the maximum limit that can be stored?
> Kindly help me.
> Regards,
> Shyam|||See if this helps:
http://vyaskn.tripod.com/handling_email_addresses_in_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam

Magic Date?

Anyone know why 1899-12-30 is a special date?
If you put that date with a time in sql server EM and a vb call will return only the time portion...
More background and sample code
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30709In vb, the date is a floating-point where the integer portion is the date. 12/30/1899 is the base date. So if you enter a time only, the integer portion of the datetime will be 0 and the decimal portion will be the time.|||What's EM Built in? If you just enter a time through EM, it'll ne 1899-12-30...

And isn't 1900-01-01 the 0 date for sql server?

SELECT CONVERT(datetime,0,101)

???

And why, if you call sql server from vb through ado, does it pass back just the time component...with no conversion function?|||I wonder if there is a magic time, that just returns the date...

Why the original developer didn't use CONVERT is betond me...|||Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.|||SELECT CONVERT(datetime,-2,101)
gives '1899-12-30 00:00:00.000'|||Originally posted by rnealejr
Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.

What does that mean?

Datetime is stored as a number...4 before the decimal, 4 after...

What do you mean time only?|||So what does this prove?

SELECT DATEADD(d,1,CONVERT(datetime,0.1))

Add 1 what?

What do you mean with no date? There's always a date component?

0 is the default

(Unless of course you add through EM then it's -2)

huh?

And why, if you make a sql call from vb, and the date is 1899-12-30, it only returns the time..VERY bizzare|||Just had the developer do it from an Excel workbook too.

It puts just the time in the Cell with that 1899-12-03 date

It doesn't return the date...bizzaro

Anyone else seen this?|||http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27101

Hey Brett ... some more with excel problems ...

I believe the reason is that while SQL takes the default date to be 1900-01-01

and other MS applications use 1899-12-30

Here is a link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/whatisdatehowdiditgetthere.asp|||Thanks...forgot all about that thread...

Still doesn't explain you only get the decimal portion of the datetime field though (that's the time component)

Macintosh Excel v.x Rendering

We have built a new front end to the report server to run reports. When
making calls to the RS Web Service, is there anything special that needs to
be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC
OS X with Office v.x. We thought that SP1 would take care of their ability
to open the xls files as with prior versions of PC xls before Office XP.
After further testing, the MAC version still does not open the excel file
correctly. It only has MIME type values in the file. What are the options
to ensure MAC Excel opens the same as PC Excel with SP1? We currently have
them export to CSV and then open that in excel with the text to columns
re-formatting. Any help you could provide would be greatly appreciated.Have you tried to export the file using a PC, save it to disk and then open
it on the Mac? I wouldn't be surprised if there were some glitches.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <Lance@.discussions.microsoft.com> wrote in message
news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> We have built a new front end to the report server to run reports. When
> making calls to the RS Web Service, is there anything special that needs
> to
> be done for Excel (xls) rendering? We have a few clients utlizing Apple
> MAC
> OS X with Office v.x. We thought that SP1 would take care of their
> ability
> to open the xls files as with prior versions of PC xls before Office XP.
> After further testing, the MAC version still does not open the excel file
> correctly. It only has MIME type values in the file. What are the
> options
> to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> have
> them export to CSV and then open that in excel with the text to columns
> re-formatting. Any help you could provide would be greatly appreciated.|||Yes...It works fine if I save down to Excel 95-2000 workbook and then send
it. The mac opens fine, but that is not a viable solution to our problem as
the mac clients will need to run reports on demand. Do you by chance know
if there is a solution in the works to ensure MAC Excel versions export
without incidence as the PC version?
Thanks...
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Have you tried to export the file using a PC, save it to disk and then
open
> it on the Mac? I wouldn't be surprised if there were some glitches.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > We have built a new front end to the report server to run reports. When
> > making calls to the RS Web Service, is there anything special that needs
> > to
> > be done for Excel (xls) rendering? We have a few clients utlizing Apple
> > MAC
> > OS X with Office v.x. We thought that SP1 would take care of their
> > ability
> > to open the xls files as with prior versions of PC xls before Office XP.
> > After further testing, the MAC version still does not open the excel
file
> > correctly. It only has MIME type values in the file. What are the
> > options
> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> > have
> > them export to CSV and then open that in excel with the text to columns
> > re-formatting. Any help you could provide would be greatly appreciated.
>|||So what happens if you open the workbook directly in Excel on the mac (don't
open it in PC Excel)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Yes...It works fine if I save down to Excel 95-2000 workbook and then send
> it. The mac opens fine, but that is not a viable solution to our problem
> as
> the mac clients will need to run reports on demand. Do you by chance know
> if there is a solution in the works to ensure MAC Excel versions export
> without incidence as the PC version?
> Thanks...
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Have you tried to export the file using a PC, save it to disk and then
> open
>> it on the Mac? I wouldn't be surprised if there were some glitches.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > We have built a new front end to the report server to run reports.
>> > When
>> > making calls to the RS Web Service, is there anything special that
>> > needs
>> > to
>> > be done for Excel (xls) rendering? We have a few clients utlizing
>> > Apple
>> > MAC
>> > OS X with Office v.x. We thought that SP1 would take care of their
>> > ability
>> > to open the xls files as with prior versions of PC xls before Office
>> > XP.
>> > After further testing, the MAC version still does not open the excel
> file
>> > correctly. It only has MIME type values in the file. What are the
>> > options
>> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
>> > have
>> > them export to CSV and then open that in excel with the text to columns
>> > re-formatting. Any help you could provide would be greatly
>> > appreciated.
>>
>|||The document is garbage...It looks exactly what happens when someone who has
a lower version of excel than XP.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> So what happens if you open the workbook directly in Excel on the mac
(don't
> open it in PC Excel)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
send
> > it. The mac opens fine, but that is not a viable solution to our
problem
> > as
> > the mac clients will need to run reports on demand. Do you by chance
know
> > if there is a solution in the works to ensure MAC Excel versions export
> > without incidence as the PC version?
> >
> > Thanks...
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> Have you tried to export the file using a PC, save it to disk and then
> > open
> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> > We have built a new front end to the report server to run reports.
> >> > When
> >> > making calls to the RS Web Service, is there anything special that
> >> > needs
> >> > to
> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> > Apple
> >> > MAC
> >> > OS X with Office v.x. We thought that SP1 would take care of their
> >> > ability
> >> > to open the xls files as with prior versions of PC xls before Office
> >> > XP.
> >> > After further testing, the MAC version still does not open the excel
> > file
> >> > correctly. It only has MIME type values in the file. What are the
> >> > options
> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
currently
> >> > have
> >> > them export to CSV and then open that in excel with the text to
columns
> >> > re-formatting. Any help you could provide would be greatly
> >> > appreciated.
> >>
> >>
> >
> >
>|||In SP1, we support Excel 97 and 2000. You should not get a MIME document
after applying the service pack.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> The document is garbage...It looks exactly what happens when someone who
> has
> a lower version of excel than XP.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> So what happens if you open the workbook directly in Excel on the mac
> (don't
>> open it in PC Excel)?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> send
>> > it. The mac opens fine, but that is not a viable solution to our
> problem
>> > as
>> > the mac clients will need to run reports on demand. Do you by chance
> know
>> > if there is a solution in the works to ensure MAC Excel versions export
>> > without incidence as the PC version?
>> >
>> > Thanks...
>> >
>> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> >> Have you tried to export the file using a PC, save it to disk and then
>> > open
>> >> it on the Mac? I wouldn't be surprised if there were some glitches.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server Reporting Services
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> >> > We have built a new front end to the report server to run reports.
>> >> > When
>> >> > making calls to the RS Web Service, is there anything special that
>> >> > needs
>> >> > to
>> >> > be done for Excel (xls) rendering? We have a few clients utlizing
>> >> > Apple
>> >> > MAC
>> >> > OS X with Office v.x. We thought that SP1 would take care of their
>> >> > ability
>> >> > to open the xls files as with prior versions of PC xls before Office
>> >> > XP.
>> >> > After further testing, the MAC version still does not open the excel
>> > file
>> >> > correctly. It only has MIME type values in the file. What are the
>> >> > options
>> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> currently
>> >> > have
>> >> > them export to CSV and then open that in excel with the text to
> columns
>> >> > re-formatting. Any help you could provide would be greatly
>> >> > appreciated.
>> >>
>> >>
>> >
>> >
>>
>|||I understand that, but the MAC version still gets this MIME document...The
PC version is fine.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> In SP1, we support Excel 97 and 2000. You should not get a MIME document
> after applying the service pack.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > The document is garbage...It looks exactly what happens when someone who
> > has
> > a lower version of excel than XP.
> >
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> >> So what happens if you open the workbook directly in Excel on the mac
> > (don't
> >> open it in PC Excel)?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> > send
> >> > it. The mac opens fine, but that is not a viable solution to our
> > problem
> >> > as
> >> > the mac clients will need to run reports on demand. Do you by chance
> > know
> >> > if there is a solution in the works to ensure MAC Excel versions
export
> >> > without incidence as the PC version?
> >> >
> >> > Thanks...
> >> >
> >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> >> Have you tried to export the file using a PC, save it to disk and
then
> >> > open
> >> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >> >>
> >> >> --
> >> >> Brian Welcker
> >> >> Group Program Manager
> >> >> Microsoft SQL Server Reporting Services
> >> >>
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >>
> >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> >> > We have built a new front end to the report server to run reports.
> >> >> > When
> >> >> > making calls to the RS Web Service, is there anything special that
> >> >> > needs
> >> >> > to
> >> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> >> > Apple
> >> >> > MAC
> >> >> > OS X with Office v.x. We thought that SP1 would take care of
their
> >> >> > ability
> >> >> > to open the xls files as with prior versions of PC xls before
Office
> >> >> > XP.
> >> >> > After further testing, the MAC version still does not open the
excel
> >> > file
> >> >> > correctly. It only has MIME type values in the file. What are
the
> >> >> > options
> >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > currently
> >> >> > have
> >> >> > them export to CSV and then open that in excel with the text to
> > columns
> >> >> > re-formatting. Any help you could provide would be greatly
> >> >> > appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Any suggestions or comments?
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I understand that, but the MAC version still gets this MIME document...The
> PC version is fine.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > In SP1, we support Excel 97 and 2000. You should not get a MIME document
> > after applying the service pack.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > The document is garbage...It looks exactly what happens when someone
who
> > > has
> > > a lower version of excel than XP.
> > >
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> > >> So what happens if you open the workbook directly in Excel on the mac
> > > (don't
> > >> open it in PC Excel)?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
then
> > > send
> > >> > it. The mac opens fine, but that is not a viable solution to our
> > > problem
> > >> > as
> > >> > the mac clients will need to run reports on demand. Do you by
chance
> > > know
> > >> > if there is a solution in the works to ensure MAC Excel versions
> export
> > >> > without incidence as the PC version?
> > >> >
> > >> > Thanks...
> > >> >
> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > >> >> Have you tried to export the file using a PC, save it to disk and
> then
> > >> > open
> > >> >> it on the Mac? I wouldn't be surprised if there were some
glitches.
> > >> >>
> > >> >> --
> > >> >> Brian Welcker
> > >> >> Group Program Manager
> > >> >> Microsoft SQL Server Reporting Services
> > >> >>
> > >> >> This posting is provided "AS IS" with no warranties, and confers
no
> > >> > rights.
> > >> >>
> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > >> >> > We have built a new front end to the report server to run
reports.
> > >> >> > When
> > >> >> > making calls to the RS Web Service, is there anything special
that
> > >> >> > needs
> > >> >> > to
> > >> >> > be done for Excel (xls) rendering? We have a few clients
utlizing
> > >> >> > Apple
> > >> >> > MAC
> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
> their
> > >> >> > ability
> > >> >> > to open the xls files as with prior versions of PC xls before
> Office
> > >> >> > XP.
> > >> >> > After further testing, the MAC version still does not open the
> excel
> > >> > file
> > >> >> > correctly. It only has MIME type values in the file. What are
> the
> > >> >> > options
> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > > currently
> > >> >> > have
> > >> >> > them export to CSV and then open that in excel with the text to
> > > columns
> > >> >> > re-formatting. Any help you could provide would be greatly
> > >> >> > appreciated.
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||We aren't generating MIME any more. That code is gone. Something else must
be wrong with the file type. We will take a look but it is not a highly
demanded scenario.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23FHK6dSiEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Any suggestions or comments?
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I understand that, but the MAC version still gets this MIME
>> document...The
>> PC version is fine.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> > In SP1, we support Excel 97 and 2000. You should not get a MIME
>> > document
>> > after applying the service pack.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >
>> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
>> > > The document is garbage...It looks exactly what happens when someone
> who
>> > > has
>> > > a lower version of excel than XP.
>> > >
>> > >
>> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
>> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> > >> So what happens if you open the workbook directly in Excel on the
>> > >> mac
>> > > (don't
>> > >> open it in PC Excel)?
>> > >>
>> > >> --
>> > >> Brian Welcker
>> > >> Group Program Manager
>> > >> SQL Server Reporting Services
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >>
>> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
> then
>> > > send
>> > >> > it. The mac opens fine, but that is not a viable solution to our
>> > > problem
>> > >> > as
>> > >> > the mac clients will need to run reports on demand. Do you by
> chance
>> > > know
>> > >> > if there is a solution in the works to ensure MAC Excel versions
>> export
>> > >> > without incidence as the PC version?
>> > >> >
>> > >> > Thanks...
>> > >> >
>> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
>> message
>> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > >> >> Have you tried to export the file using a PC, save it to disk and
>> then
>> > >> > open
>> > >> >> it on the Mac? I wouldn't be surprised if there were some
> glitches.
>> > >> >>
>> > >> >> --
>> > >> >> Brian Welcker
>> > >> >> Group Program Manager
>> > >> >> Microsoft SQL Server Reporting Services
>> > >> >>
>> > >> >> This posting is provided "AS IS" with no warranties, and confers
> no
>> > >> > rights.
>> > >> >>
>> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > >> >> > We have built a new front end to the report server to run
> reports.
>> > >> >> > When
>> > >> >> > making calls to the RS Web Service, is there anything special
> that
>> > >> >> > needs
>> > >> >> > to
>> > >> >> > be done for Excel (xls) rendering? We have a few clients
> utlizing
>> > >> >> > Apple
>> > >> >> > MAC
>> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
>> their
>> > >> >> > ability
>> > >> >> > to open the xls files as with prior versions of PC xls before
>> Office
>> > >> >> > XP.
>> > >> >> > After further testing, the MAC version still does not open the
>> excel
>> > >> > file
>> > >> >> > correctly. It only has MIME type values in the file. What are
>> the
>> > >> >> > options
>> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
>> > > currently
>> > >> >> > have
>> > >> >> > them export to CSV and then open that in excel with the text to
>> > > columns
>> > >> >> > re-formatting. Any help you could provide would be greatly
>> > >> >> > appreciated.
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>