Question specific to Excel Services 2007: Can I publish a plain SQL table through excel services 2007?

Question

Hi,

Can I publish a plain SQl table through excel services 2007?

Just to clarify, I do not need to publish any pivot table, just a plain sql table.

Thank you,

Answer 1

 

Hi amx2012,

If your excel sheets have some query tables where the data is from SQL database ,they will not be published. If you want only display SQL table in your SharePoint, I suggest you use BDC(Business Data Catalog) in SharePoint.

You can refer to the following link.

http://pramodaachi.blog.com/2010/03/23/business-data-catalog-for-moss-2007-how-it-works/

http://msdn.microsoft.com/en-us/library/ms563661(v=office.12).aspx

Thanks,

Jack