Exporting table column type 'Long Text' to Excel

• Essex

  Mr or Mrs. 500

  Points: 552

  More actions

  August 8, 2011 at 2:23 am

  #255331

  Hi, I am using the standard table export within SQL Server 2008 R2 to send my data to Excel.

  However, should the table require a conversion to Excel's Long Text type AND contain data then I get an error: The originating column type is typically VARCHAR of 50+ characters.

  Messages

  * Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)

  * Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)

  * Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE `Employees` (

  `ID` Long,

  `EmployeeCode` Lon..." failed with the following error: "The Microsoft Jet database engine could not find the object 'Employees'.

  Make sure the object exists and that you spell its name and the path name correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,

  parameters not set correctly, or connection not established correctly.

  (SQL Server Import and Export Wizard)

  - Copying to `Employees` (Stopped)

  I have googled many an answer but most are associated with scripts and/or imports.

  Currently I am exporting results grid with headers to either .csv and importing into Excel or simply cut/paste but this is cumbersome and I have to watch for non general data types where I may get leading zeros dropped etc. Not ideal.

  Any help appreciated. Thanks

• Essex

  Mr or Mrs. 500

  Points: 552

  More actions

  August 8, 2011 at 5:50 am

  #1365115

  Hi, thanks for the reply. The version of Office / Excel I have installed is 2010 though I tried to specify the destination version as both version 97-2003 and then 2007. You have me on the Jet & ACE aspect though so maybe I should look that up.

  Many thanks for the prompt reply