P
paras.shah
Need some help.
Currently need to convert table from excel to a flat file in Access.
Current data looks like this (example) ->
Fruit Jan Feb Mar Apr
Apple 10 12 15 20
Pear 0 20 3 10
Banana 1 10 17 2
and I need to get it like this ->
Fruit Month Qty
Apple Jan 10
Apple Feb 12
Apple Mar 15
Apple Apr 20
Pear Jan 0
and so on.
I have tried to do this in excel by pivot table but I have a table
that once converted exceeds 65K records.
The reason is that I have multiple feeds of different formats, and
once they are in this flat file format, it is easier to work when
dealing with writing queries.
Does anyone know of a way to do this in Access 2003? I am pulling my
hair out trying to figure it out.
Thanks
Currently need to convert table from excel to a flat file in Access.
Current data looks like this (example) ->
Fruit Jan Feb Mar Apr
Apple 10 12 15 20
Pear 0 20 3 10
Banana 1 10 17 2
and I need to get it like this ->
Fruit Month Qty
Apple Jan 10
Apple Feb 12
Apple Mar 15
Apple Apr 20
Pear Jan 0
and so on.
I have tried to do this in excel by pivot table but I have a table
that once converted exceeds 65K records.
The reason is that I have multiple feeds of different formats, and
once they are in this flat file format, it is easier to work when
dealing with writing queries.
Does anyone know of a way to do this in Access 2003? I am pulling my
hair out trying to figure it out.
Thanks