Normalizing(?) problem

[jboman]

Hi gurus,
I tried the search before posting, but nothing on this topic came up, so here we go.

I have a problem where I've imported data from Excel. The tabel looks like this:

Material - Jan 2011 - Feb 2011 - Mar 2011 -
a - 2000 - 3000 - 5000 -

...and so on, each new month has a separate column with quantites for materials.

There are a lot of columns and I'd like to accomplish the following result table with a query or some VBA code:

Material - Month - Year - Qty
a - Jan - 2011 - 2000
a - Feb - 2011 - 3000


a - Mar - 2011 - 5000

This is a common problem with Excel templates that people use. They are ok for editing data in Excel, but are useless for Access import.

Any help is much appreciated!

BR.

[orange]

Seems you have already recognized that Spreadsheet<>Table.

There is an article at the site below that overviews RDBMS that may be helpful with concepts
http://forums.aspfree.com/microsoft-...es-208217.html