0

We're facing a massive data migration that consists of about 1500 Excel Spreadsheets that were used to print out data. Because they were designed to be visual, the data is stored in several fields throughout the spreadsheet. I'm looking for a way to map out those fields, and then do a bulk import to bring all of it into a single large table (or series of tables, if needed).

If it was all in a table format, this wouldn't be a problem - but I'm not sure of any way to import, and somehow map the fields to be imported).

Any thoughts or ideas?

STLCajun
  • 85
  • 6
  • Can you elaborate on how the data is stored in the EXCEL? Also what is the Target DB and Version? – Chandu Jul 12 '11 at 15:48

1 Answers1

0

If we're speaking in generalities, I'd look at performing this task via a .NET program and use the ACE OLEDB provider to query the Excel data. Then use the language of your choice to parse the data into something more manageable and write to the database. This approach worked well to import some very non-tabular data into SQL Server.

Quick list of SO questions with C# examples of code to query Excel.

Community
  • 1
  • 1
billinkc
  • 59,250
  • 9
  • 102
  • 159