S
Steve
I am creating an e-commerce web site for a customer, and one of the
things that needs to be done is to populate the database with the
inventory. The customer is most comfortable with Excel, and would like
to be able to enter all the inventory information in a worksheet. Then,
the data from the worksheet will be exported to a CSV file and imported
into the database. The problem that I have is converting the data to
multiple tables in the database. As with any database, there is a
name/description that the customer sees, and key value that is used by
the database for the linking the tables together. What I would like to
know is this; is it possible to create a combo box in Excel where the
name is selected from the list, but the actual value that is saved is a
code? From what I've read so far (from searching the archives and
www.contectures.com), it is possible to create lists, but containing
only one column. However, in looking at the properties for a combo box,
there is a Bound Column property, similar to the same property for a
combo box in Excel, which leads me to believe what I want to do is possible.
Thanks.
Steve
things that needs to be done is to populate the database with the
inventory. The customer is most comfortable with Excel, and would like
to be able to enter all the inventory information in a worksheet. Then,
the data from the worksheet will be exported to a CSV file and imported
into the database. The problem that I have is converting the data to
multiple tables in the database. As with any database, there is a
name/description that the customer sees, and key value that is used by
the database for the linking the tables together. What I would like to
know is this; is it possible to create a combo box in Excel where the
name is selected from the list, but the actual value that is saved is a
code? From what I've read so far (from searching the archives and
www.contectures.com), it is possible to create lists, but containing
only one column. However, in looking at the properties for a combo box,
there is a Bound Column property, similar to the same property for a
combo box in Excel, which leads me to believe what I want to do is possible.
Thanks.
Steve