Urgent help needed

[Bee]

Hi,

I'm importing data of a query to excel from access; however, all fields that have combobox for input display numbers instead of text.

Any help will be very much appreciated.
B

 

[ideefixe]

Hi,

I'm importing data of a query to excel from access; however, all fields that have combobox for input display numbers instead of text.

Any help will be very much appreciated.
B

The numeric values are probably being stored in lookup tables somewhere. You will need to design a query joining the numbers to the corresponding numbers in the lookup tables and export the results of that into excel.

 

[Bee]

The numeric values are probably being stored in lookup tables somewhere. You will need to design a query joining the numbers to the corresponding numbers in the lookup tables and export the results of that into excel.

The results appear fine in my query when I run it. The change only happen when excel pulls data from Access!
I don't quite know what you mean.

 

[gemma-the-husky]

is there an option to save fields as formatted?

if not its probably one of the drawbacks of using lookups in table definitions. You will probably have to recreate the lookup in your query to get the field value you REALLY want.

Are you using docmd.transferspreadsheet for this?

 

[Bee]

is there an option to save fields as formatted?

if not its probably one of the drawbacks of using lookups in table definitions. You will probably have to recreate the lookup in your query to get the field value you REALLY want.

Are you using docmd.transferspreadsheet for this?

Yes I am using the docmd.transferspreadsheet.
I was using the look up, but when I realized my stupid mistake. I am now switching to "formatting" as I tried it with the spreadsheet and it worked fine.