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 |
|
Togaspoon
Starting Member
42 Posts |
 Posted - 2015-03-05 : 16:27:18
|
| I need to import a excel file into sql from one of our vendors.The file is laid out like a report:screenshotBasically the key is on a row and then the data is on the next N number of rows. Can SSIS handle a situation like this?Edit Fix link |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Togaspoon
Starting Member
42 Posts |
Posted - 2015-03-05 : 16:33:45
|
| Better? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-05 : 17:29:06
|
| I think SSIS can handle it, but it wouldn't be a simple import. I'm not sure though. Can the vendor make it csv instead?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Togaspoon
Starting Member
42 Posts |
Posted - 2015-03-06 : 11:12:24
|
| I've asked, but I don't think it's likely. |
|
|
|
|
|
|
Excel record on multiple rows