Dear Community,
I am in the process of building my first database for all kinds of lubricants that my employer sells.
However, I am now stuck trying to figure out how I can import the data from excell into a dropdown list with 7 values total.
These values are: Can, Spray Can, Pail, Drum, Drum limited edition and Cartridge.
The excell data looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Itemcode[/TD]
[TD]Packaging[/TD]
[/TR]
[TR]
[TD]250004[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250011[/TD]
[TD]Pail[/TD]
[/TR]
[TR]
[TD]250028[/TD]
[TD]Drum[/TD]
[/TR]
[TR]
[TD]250035[/TD]
[TD]Drum limited edition[/TD]
[/TR]
[TR]
[TD]250042[/TD]
[TD]Pail[/TD]
[/TR]
[TR]
[TD]250059[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250066[/TD]
[TD]Cartridge[/TD]
[/TR]
[TR]
[TD]250073[/TD]
[TD]Spray Can[/TD]
[/TR]
[TR]
[TD]250080[/TD]
[TD]IBC[/TD]
[/TR]
[TR]
[TD]250097[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250117[/TD]
[TD]Drum[/TD]
[/TR]
[TR]
[TD]250120[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250122[/TD]
[TD]IBC[/TD]
[/TR]
</tbody>[/TABLE]
My question: How can I import this data from Excell into a dropdownlist with the same values in Access. I know how to create a dropdown list with the 7 values, so that is not the problem. The problem is getting the data of over 800 records into an access field with the dropdown list data type, without having to manually do it for every record.
Kind Regards,
Steyn Hendriksen.
I am in the process of building my first database for all kinds of lubricants that my employer sells.
However, I am now stuck trying to figure out how I can import the data from excell into a dropdown list with 7 values total.
These values are: Can, Spray Can, Pail, Drum, Drum limited edition and Cartridge.
The excell data looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Itemcode[/TD]
[TD]Packaging[/TD]
[/TR]
[TR]
[TD]250004[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250011[/TD]
[TD]Pail[/TD]
[/TR]
[TR]
[TD]250028[/TD]
[TD]Drum[/TD]
[/TR]
[TR]
[TD]250035[/TD]
[TD]Drum limited edition[/TD]
[/TR]
[TR]
[TD]250042[/TD]
[TD]Pail[/TD]
[/TR]
[TR]
[TD]250059[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250066[/TD]
[TD]Cartridge[/TD]
[/TR]
[TR]
[TD]250073[/TD]
[TD]Spray Can[/TD]
[/TR]
[TR]
[TD]250080[/TD]
[TD]IBC[/TD]
[/TR]
[TR]
[TD]250097[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250117[/TD]
[TD]Drum[/TD]
[/TR]
[TR]
[TD]250120[/TD]
[TD]Can[/TD]
[/TR]
[TR]
[TD]250122[/TD]
[TD]IBC[/TD]
[/TR]
</tbody>[/TABLE]
My question: How can I import this data from Excell into a dropdownlist with the same values in Access. I know how to create a dropdown list with the 7 values, so that is not the problem. The problem is getting the data of over 800 records into an access field with the dropdown list data type, without having to manually do it for every record.
Kind Regards,
Steyn Hendriksen.