Values of ComboBox fields and SQL
Major headache: For one I want to take a Excel file and maybe using DTS in
SQL write the values in the database.
On the spreadsheet I have created a "form" some of which is active-x control
ComboBox, I have one sheet just to get all my values (BUT I dont know how to
get the value of a ComboBox ??) for example to get one of the cells used as a
form, I would have ='Daily Log'!D4 - using this system I have one worksheet
where I get all the values in each column (or row, what ever is better later
in creating some DTS script) BUT I cant get the value of the form where I
have a ComboBox (not sure how to do this?) I tried Form.ComboBox1 etc...
The other side is then to save it in one location and getting some DTS
script to get these values and save them into the database.
Anton
|