Comments on: reformatting a multi-tab spreadsheet and access 2003http://itknowledgeexchange.techtarget.com/itanswers/reformatting-a-multi-tab-spreadsheet-and-access-2003/
Sun, 02 Aug 2015 08:47:57 +0000hourly1By: chippy088http://itknowledgeexchange.techtarget.com/itanswers/reformatting-a-multi-tab-spreadsheet-and-access-2003/#comment-84615
Wed, 01 Dec 2010 13:42:20 +0000#comment-84615This is a task I’ve done many times, and never the same way each time. It is made harder by the different ways data is entered and used, (calculations etc.) The main problem is you need to understand the interaction between each sheet in the whole workbook.

As you haven’t given any indication of what sort of data (and their relationships,) is in the workbook sheets, I can only give you a general idea.

I would suggest that you start by copying all the column headings of each sheet, to a check list, then work out which ones are the result of calculations, and whether they are then used in another sheet. This is no easy task, but you really don’t want to take unneeded columns across. Particular attention needs to be taken with linking data from different sheets, using a primary key, if this doesn’t work, then you will need to use more than 1 table in the new database you create.

You then need to create the new database with the characteristics of the data cells set up.

I create a duplicate spreadsheet, and copy real data into it, from the live workbook, to check the results when it is entered into the new DB.

Without more information, I can only suggest guide lines for you to try. As I said before, each time I’ve done this it has been different. Good luck, post more observations if you need further assistance.