I have a project where we have to compile multiple (30+) copies of an excel workbook into essentially one master workbook. The data is then pushed out again. And summary reports are written. Each workbook has about 20 sheets in it. The column names on each page are often vague.
We've thought about a database with a table representing each sheet. Uploading from a workbook is tricky (they don't want to export each sheet to csv and then upload them individually), or so it seems. I'm not a VB programmer (hence the post here).
I thought about turning the workbook into an Adobe Acrobat form (20 pages or so). It works in test, but making the form is tedious work and there's no export capability back to a worksheet (although perhaps that isn't absolutely necessary).
Google answers have ODBC plugins and Navicat imports, neither of which truly resolve my question.
I'm just trolling around for new ideas, past experiences, war stories.
Ken
Tags: