Post reply

Exporting table column type 'Long Text' to Excel

  • 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

  • August 8, 2011 at 5:38 am

    This was removed by the editor as SPAM

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply