Import Excel to Sql table

Question

Import Excel to Sql table

scuby.me

Mr or Mrs. 500

Points: 587
More actions
November 5, 2013 at 10:35 am

#278907

Can anyone help me on this. what is the easiest way to do this? I used a excel source and oledbdestination. That worked fine before but now it doesn't import to sql table. I don't know why..

Viewing 5 posts - 1 through 4 (of 4 total)

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

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

What's the output you're getting? There are millions of reasons, but the error messages can help us to identify what's happening.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

scuby.me Mr or Mrs. 500 Points: 587 More actions · Answer 2

"Truncation may occur due to inserting data from data flow column with a length of 255 to database column with a length of 9"

Tee Time Hall of Fame Points: 3745 More actions · Answer 3

Are you attempting this using the SSIS Import and Export Wizard under the Project menu item of BIDS?

Honny Old Hand Points: 394 More actions · Answer 4

While importing the Data from Files check for the Length and data type of the Columns and better to use LTRIM and RTRIM Functions it gives you performance wise good results.

Post the Exact Error Message your getting in the Bottom window....