November 26, 2010 at 11:45 pm
Hi Guys
Attached is a complex spreadsheet that is filled out by boat captains at sea and is emailed into a central office which then needs to be imported
As you can see its not an ideal format for sql but the data needs to go from there into sql server.
What is the best way to so this? I was thinking about using ssis, importing all into a holding table and then manipulate with t-sql but that sounds like a lot of pain! Maybe a c# script would do the trick? Whats the most efficient solution for this?
What would an MVP do? 🙂
thanks guys
Chris
November 27, 2010 at 2:55 am
I'm definitely not an MVP, but the most efficient solution from my point of view is to get the people involved who provide the report, ask where they get the data from and talk to the people responsible for the raw data to get a separate file with structured data.
But if you really want to import those files, make sure you detect all changes in structure (like adding columns, renaming headers, moving positions between both, columns and rows, renaming worksheets). The import will be a nightmare to implement subjected to fail sooner or later.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply