How to replicate records based on a variable

[henio]

Hi all,
I have an Excel spreadsheet which could be loaded into a table) which looks like:

Description Qty
Beer 2
Wine 5
Spirits 8

I need to create a table which looks like:

Beer 2
Beer 2
Wine 5
Wine 5
Wine 5
Wine 5
Wine 5
Spirits 8
Spirits 8
etc.

Can anyone please help?
Cheers,
Henio

 

[zrzr]

You can use VBA :

'first, put the first table on a recordset

dim rec as DAO.Recordset
set rec = CurrentDB.OpenRecordset("Name of the first table&quot

'then, for each line of the first table, insert
some lines into the second
Dim i as Integer
Dim str as String
Do While rec.EOF = False
For i=1 To rec("Qty&quot
str = "INSERT INTO nameOfTheSecondTable _
Select '" & rec("Description&quot & _
"', " & rec("Qty&quot & " ;"
DoCmd.RunSQL (str)
Next i
rec.MoveNext
loop

rec.close

I hope it'll work !!!