Hello All,
I have done some VBA to export a query into excel which was easy. Issue is that this is then to be imported into another DB.
There are several combo boxes that take data from other tbls, instead of exporting the number it exports the actual text, this owuld be fine except when you import this into the other DB none of it works as it is a number not a text value for them fields.
Anyone know how to export the number of the combo fields and not the text into a spreadsheet? Hope that makes sense!
I have done some VBA to export a query into excel which was easy. Issue is that this is then to be imported into another DB.
There are several combo boxes that take data from other tbls, instead of exporting the number it exports the actual text, this owuld be fine except when you import this into the other DB none of it works as it is a number not a text value for them fields.
Anyone know how to export the number of the combo fields and not the text into a spreadsheet? Hope that makes sense!