dbTalk Databases Forums  

Opening Excel 2007 files with DTS

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


Discuss Opening Excel 2007 files with DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM






Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #12  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM






Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #13  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM



Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #14  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM



Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #15  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM



Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #16  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM



Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
  #17  
Old   
FredG
 
Posts: n/a

Default Re: Opening Excel 2007 files with DTS - 10-16-2008 , 09:19 AM



Sorry for the late reply.

Yes we do have 2007 installed.

DTS Designer doesn’t give me the option for MS excel 2007. If I select the
MS Excel Driver which has .XLSX listed in it then I will have to create a
data source for each .xlsx file that the DTS will be loading. If I have to do
this then all my DTS transformations need to be recreated.

I am guessing there is a smarter better way of doing this which I don’t know.


"Dave Patrick" wrote:

Quote:
Do you have excel 2007 installed on server?


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"FredG" wrote:
Hello Gurus,

Enviroment:
SQL Server 2000 SP4 Build 2187
Windows 2003 SP2

Receiving the following error
Microsoft Excel Open method of Workbooks class failed' because the server
is not able to recognize excel 2007 file

Does anyone have a workaround?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.