Home Forums SQL Server 2005 SQL Server 2005 General Discussion Opendatasource problems with excel RE: Opendatasource problems with excel
Glen
SSCertifiable
Points: 6737
More actions
September 8, 2008 at 1:00 pm
#868684
Shouldn't it be Excel 8.0 for Excel 2002 in extended properties.
Also, MS recommends using OPENDATASOURCE for only infrequent access. Did you try linked server instead?
http://support.microsoft.com/kb/321686