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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Excel record on multiple rows

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:

screenshot

Basically 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

Posted - 2015-03-05 : 16:29:45
The link doesn't work.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Togaspoon
Starting Member

42 Posts

Posted - 2015-03-05 : 16:33:45
Better?
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Togaspoon
Starting Member

42 Posts

Posted - 2015-03-06 : 11:12:24
I've asked, but I don't think it's likely.
Go to Top of Page
   

- Advertisement -