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 |
|
dnpmoris
Starting Member
23 Posts |
 Posted - 2006-10-03 : 14:44:04
|
| I have one .xl file with siteid and ADA (2 columns and 880 rows)I have a table with name Site with 10 columns. in that table siteid is the primary key.Now i am adding one more column to the table with name ADA.Now I have to import from .xl file ADA values into my site table based on siteid. Now I went to Database choose Datatransformation services and selected Local package and right click selected new package...it shows one window... after I took one sql connection and task as Bult insert properties..in that i gave destination table and source data file and i trying to choose row delimitor and column delimitor (in deffrent ways...).once i am running the package ..it is saying bulk insert fails make sure row delimitor and column delimitor is specified correctly? you have any idea to import...as per knowledge I am trying thru packages...(i can do just update select statement)...i want to try some thing defferent..with sigle click... |
|
|
|
|
|
Need help in microsoft xl file into sqlserver tabl