G
Guest
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
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