D
datatransfer
Hello all,
We have a situation where we need to transfer data from an Exce
spreadsheet to a SQL Server database. The excel spreadhseet has 2
fields of which 5 fields have all rows overlayed by combobox controls
The values for the list in the combobox controls comes from elsewher
in the same spreadsheet. Please note here that the cells on top o
which the combobox controls are overlayed are NOT linked to th
combobox.
The problem is that when I try to export the data (everything includin
the values in the comboboxes), since the cells themselves don't hol
the values of the comboxes, nothing gets exported for those fields.
tried to 'Save As' 'txt' and csv' but the data from the comboboxes doe
not get exported.
Another thing to note is that the names of the comboxes seems t
generated by Excel. They have names like 'Drop Down 1645', 'Drop Dow
1646' etc.
Can someone help me on how to get the values of the comboboxes whil
exporting or to another field (using a macro or such)? I'm a databas
administrator and am not very familiar with VBA coding but ca
implement it if pointed in the right direction.
Any help is greatly appreciated. I have been stuck with this for over
days.
Please let me know if you have any questions.
Thanks,
D
We have a situation where we need to transfer data from an Exce
spreadsheet to a SQL Server database. The excel spreadhseet has 2
fields of which 5 fields have all rows overlayed by combobox controls
The values for the list in the combobox controls comes from elsewher
in the same spreadsheet. Please note here that the cells on top o
which the combobox controls are overlayed are NOT linked to th
combobox.
The problem is that when I try to export the data (everything includin
the values in the comboboxes), since the cells themselves don't hol
the values of the comboxes, nothing gets exported for those fields.
tried to 'Save As' 'txt' and csv' but the data from the comboboxes doe
not get exported.
Another thing to note is that the names of the comboxes seems t
generated by Excel. They have names like 'Drop Down 1645', 'Drop Dow
1646' etc.
Can someone help me on how to get the values of the comboboxes whil
exporting or to another field (using a macro or such)? I'm a databas
administrator and am not very familiar with VBA coding but ca
implement it if pointed in the right direction.
Any help is greatly appreciated. I have been stuck with this for over
days.
Please let me know if you have any questions.
Thanks,
D