View Complete Post
I am unable to export SharePoint Form Library view data in a Spread Sheet. Whenever I am trying , I got following error message.
An operation that uses the database driver could not be completed. If the driver is a Microsoft Driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database
administrator or driver vendor.
Any idea how to solve the problem ?
When I am trying to export the SharePoint View from SharePoint site to Spreadsheet, sometimes I am able to export the the whole data and sometimes I only get Column headers but no data or records
I have Infopath form (2007) published on SharePoint Site and I am using MOSS 2007 and Excel 2003
I am not able reach the cause of this behaivour of Export to Spreadsheet functionality
Is their a Buffer size Issue with IIS or Session time out
I am not sure because when I export to Spreadsheet and if the record goes to Spreadsheet the file size is just 1.72 MB
The lookup fields with allow multiple options enabled displays parent listitem id separated by ";#" when exporting to spreadsheet. I need to remove the #and the parent list item id from the spreadsheet. how to achieve that?
Moss 2007 -
When we are trying option export to spreadsheet from the below site, the following error displays
" Cannot connect to the server at this time. Changes to your data cannot be saved" (message box it displays).
Not working on VISTA SP1 systems only
Export SharePoint List to Excel Spreadsheet Programmatically using C# In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.