Trasform DB's data

[Maurizio]

Hi all,
with Access 2000 how can I trasform DB's data like sample:

db.xls
	A	B	C	D	E	F
1	CODICE	DDT	DESCRIZ	PGRN	KG
2	12	1	VITELLONS2		2933,1	INI
3	12	1	1619M-1324	1	0
4	12	1	77S	2	0	END
5	12	1	SOTTOFESADIMANZOSV		89	INI
6	12	1	A03448		0	END
7	17	2	CODEDIVITELLONS		10,5	INI
8	17	2	2412M-171	1	0
9	17	2	2412M-889	2	0
10	17	2	1626M-1125	3	0	END
11
12	CODICE	DDT	DESCRIZ	NOTE_RAGGR	KG
13	12	1	VITELLONS2	1619M-1324/77S	2933,1
14	12	1	SOTTOFESADIMANZOSV	A03448	89
15	17	2	CODEDIVITELLONS	2412M-171/2412M-889/1626M-1125	10,5
DBase

Tia.

 

[Yogi Anand]

Hi Maurizio:

I see your data laid out in two arrangements ...

in cells A1:E10 and cells A12:E15. Which arrangement are you trying to convert to the other -- just to be sure!

 

[Maurizio]

I'd like to convert data cells A1:E10 like data cells A12:E15.
(temp Column "F" shows different groups: A value > 0 shows INI Group, and last value = 0 shows END Group).

 

[SydneyGeek]

If the data already is in Access, you could try this:

1. Build a query to show the data in the column layout that you want.
2. Turn this into a Make-Table query to create a new table from the data. You will need to create an appropriate primary key for this new table, if you want to use it for creating / appending further records.
3. Once you hae the new table, use this one -- you can archive the original tables (export them to a new database which you could call Archive). That way, if you ever need the original data, you still have it.

HTH

Denis

 

[bat17]

I don't think that you will be able to do this with queries but will have to loop through the records with code to concatenate the records together.

Peter