October 25, 2007 at 3:23 pm
I get the errors below while trying to export data from a MS SQL 2005 (developers and Standard Editions) to a MS Excel
Any help will be appreciated.
Thanks!
- Pre-execute (Error)
Messages
* Error 0xc0202009: {CC150901-3E21-4094-AB4D-3D0FE3F54F71}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
* Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)
* Error 0xc004701a: Data Flow Task: component "Destination 64 - USERS" (5871) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)
October 26, 2007 at 4:00 am
Hi,
How are you exporting the data, if you are using creating Queries in the Management Studio I usually export the data as a csv and then load into Excel, and I find this works fairly well.
October 26, 2007 at 9:45 am
I'm exporting the whole db to excel, using SQL Native Client as Data Source and Microsoft Excel as the destination.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply