What version does SQL 2000 support for Excel.

#1

I guess the subject says it all. When I export a table into Excel, I only
have the option of Excel 5, Excel 97-2000. Can I use Excel 2k3 and if so
how? Right now the Excel file is 1MB but if I open and save the file, it
compresses down to 18k.

Mike

#2

Yep you can use 2K3. I do all the time with no issues using the Excel
connection manager (Excel 97-2000)

Allan

"Mike" <mdunlap (AT) nospam (DOT) com> wrote

Quote:

I guess the subject says it all. When I export a table into Excel, I
only
have the option of Excel 5, Excel 97-2000. Can I use Excel 2k3 and if
so
how? Right now the Excel file is 1MB but if I open and save the file,
it
compresses down to 18k.

Mike

#3

Hello Mike,

All Excel versions above 97 are compatible. I also use Excel 2003 and there
are no problems.
if there is any issue (I didn't understand well who compresses what), come
back with some details.

Good luck!
Pavel
http://www.reporting.ro/

"Mike" wrote:

Quote:

I guess the subject says it all. When I export a table into Excel, I only
have the option of Excel 5, Excel 97-2000. Can I use Excel 2k3 and if so
how? Right now the Excel file is 1MB but if I open and save the file, it
compresses down to 18k.

Mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What version does SQL 2000 support for Excel.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

What version does SQL 2000 support for Excel. - 11-09-2005 , 08:53 AM

Re: What version does SQL 2000 support for Excel. - 11-09-2005 , 02:12 PM

RE: What version does SQL 2000 support for Excel. - 11-10-2005 , 12:15 AM