importing an excel spread sheet.

[Chieko Kuroda]

Hello,
I have an excel spreadsheet that contains 8 fields and one of them is a
quantity field. Quantity means that that row is multiplied by the number
that is in that field. So if in Excel there are 3 rows and one of the rows
has 2 in the quantity field, then in Access there are really 4 records
total. I'm not sure how to create the extra record needed in Access from
importing the Excel sheet. Does anyone have any suggestions?
Thank you,
Chieko

 

[Adam]

Hi Chieko

If I have understood correctly, you are wanting to create duplicate records
where your quantity field is greater than 1. This is bad database design,
and you would probably be better off importing the data as they are without
trying to create the extra records. When you need to make use of the
information in the quantity field, you can just design your queries to take
that into account.

HTH

Adam