Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satheshvenkat
Starting Member
3 Posts |
 Posted - 2010-01-10 : 08:24:34
|
| Hello Friends,I need do import the data from MS-Excel 2003 to SQL Server 2005 database by using SQL Export Wizard.I try do import the data from MS-Excel to Database.But it is not happening.Can you tell me the procedure for importing the data to SQL Server?Thanks in advance for your kind co-operation.Regards,Sathesh. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-10 : 08:35:05
|
Go through the wizard step by step.Are there any problems for you?Errors?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-10 : 10:41:51
|
| How is the Data Layout in Excel? |
|
|
|
satheshvenkat
Starting Member
3 Posts |
Posted - 2010-01-11 : 05:20:09
|
| Hello Sodeep and Webfred,Thanks for your kind reply.Excel data layout is 4 coulumns and 4 rows in a shread sheet.In the database also same layout only.But still it is giving error in the last step while executing the file.can you tell me how do import without error?any special procedures are there do import the data? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-11 : 06:12:18
|
quote:
But still it is giving error in the last step
We cannot see the error message...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
satheshvenkat
Starting Member
3 Posts |
Posted - 2010-01-12 : 04:12:07
|
| While selecting destination database which one i have to choose either SQL Native client or Microsoft OLE DB with SQL server or something else?Am getting below errors while finishing the import producre. 1.Validating Warning Message.Message is Warning 0x80047076:Dataflow Task:Output column "Sl#NO"[15]on output "Excel Source output" and component "Source-Sheet1$"[1]is subsequently used in the dataflow task.Since my excel coulumn names are Sl.No and Name same as database table column.2.one more error is coming from Copying to DB action.Error:0xc0202009:Dataflow Task:SSIS Error code DTS_E_OLEDBERROR.An OLEDB error has occured error code:0x80004005.I have selected the destination database as Micorsoft OLEDB SQL DB. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 04:20:30
|
quote:
Originally posted by satheshvenkat
While selecting destination database which one i have to choose either SQL Native client or Microsoft OLE DB with SQL server or something else?Am getting below errors while finishing the import producre. 1.Validating Warning Message.Message is Warning 0x80047076:Dataflow Task:Output column "Sl#NO"[15]on output "Excel Source output" and component "Source-Sheet1$"[1]is subsequently used in the dataflow task.Since my excel coulumn names are Sl.No and Name same as database table column.2.one more error is coming from Copying to DB action.Error:0xc0202009:Dataflow Task:SSIS Error code DTS_E_OLEDBERROR.An OLEDB error has occured error code:0x80004005.I have selected the destination database as Micorsoft OLEDB SQL DB.
1st one is just a warning. you can ignore that. 2nd one suggests you've some error in data flow tsk.you can select Micorsoft OLEDB SQL DB for destination but make sure you set properties correctly. also are you using table or view or command option? |
|
|
|
|
|
|
how do import excel data to SQL Server 2005