This forum is closed. Thank you for your contributions.
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,
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