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 |
|
dedbeat
Starting Member
9 Posts |
 Posted - 2009-01-13 : 13:00:06
|
| hey guys,i have multiple excel files that i need to load to an existing table in sql. the files have the same layout horizontally, but the number of rows vary. they have a total of around 20 columns. also these columns do not have column names or header info.i need to skip the first 10 rows since its some file information that doesnt pertain to me. i need to get 3 specific columns, and insert it into the respective columns of the existing table. someone suggested using a range rather than sheet name but that would mean specifying the number of rows as well which i cant do, since from file to file it changes.can anyone help me write the sql query that helps me do this? also sometimes the excel sheet name can have spaces in them. do you know how i can deal with those?thanks a bunch. you guys are lifesavers. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 13:04:18
|
| seems like what you need a ssis with script task to transfer from 11 row and then use OLEDB destination to populate table. You can enclose this in a for each loop using file enumerator to loop over your files. |
 |
|
|
|
|
|
inserting data into existing table - excel to ssis