June 25, 2008 at 3:45 am
I am trying to export data from SQL server 2005 to Excel 2007 but wen i execute it at the end its shows me error.
Below is the total report:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Error)
Messages
Error 0xc002f210: Preparation SQL Task: Executing the query "CREATE TABLE `Employee` (
`Empid` VarChar(50) NOT NULL,
`Name` VarChar(50) NOT NULL,
`Position` VarChar(50)
)
" failed with the following error: "This property is not supported for external data sources or for databases created with a previous version of Microsoft Jet.". 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 `Employee` (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
Please help me out. It s urgent
June 25, 2008 at 7:35 am
Since I don't yet have a copy of Excel 2007, I'm kind of guessing here, but it looks to me like it might be a question of being unable to create a "table" in Excel. Have you tried creating the spreadsheet first, just with header rows, and then using the wizard to dump data into it?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 7:43 am
Check if a Excelsheet with same name is already present or a EXCEL file with same name.
try this:
SET ARITHABORT ON
SET ARITHIGNORE ON
Maninder
www.dbanation.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply