Sending recordset to excel

G

gr

Hi all,

I am sending a recordset to Excel. The recordset is from a
query.
It work fine except that I have some fiels which are items
choosen from comboboxes. So when the recordset is sent to
Excel, instead of displaying the values from the query, it
is displaying numbers. I think this has to do with the
Bound Columns or something of the combo box properties..

how to make excel display the "real" values?

Ex.
My query in access
Smith Sales Doc1 Finished GMD
Ravanni PIBDE Doc2 In progress SER
Ramon Sales Doc3 Finished SER

The same data in Excel
1 1 Doc1 1 1
2 2 Doc2 2 2
3 1 Doc3 1 2

Thx,
gr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Recordset sent to Excel 3
Error Exporting Access Query Results to Excel 1
Use recordset as input to Query 0
Update query to set value based on position in recordset 2
Recordset returning some fields as zero/null 0
SQL statement not working 2
Loop through recordset and create excel spreadsheets 0
Incorrect count in filtered recordset 0

Top