Query Output to Excel.

[mykd]

Hi,

I have a query which pulls key fields from a Table and exports to an excel file through the Output to cmmd.

In the table, i have defined a few fields with Look-up criteria and Combo / LIsts. When the Excel sheet is created the Lists are not downloaded. The purpose is to scrub the data and provide users an excel sheet for update of the Combo box for upload in another MS access table.

Please help, this feature is extremely critical for our work. Thanks in advance.

 

[AlexCuse]

AFAIK, you can't import excel combo boxes into access. I have never tried to put combo boxes into a table either, but it doesn't really seem like the best idea. That's what forms are for

I would try creating a function that can be used in your query to turn your combo box values into a comma separated list, and export this list to excel. Then, on the import, you can turn the list back into a collection of combo box values.

Hope this helps,

Alex

Then, on the import

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[mykd]

HI Alex, Thanks for your response.IS there any standard function that can help me. I dont know much programming and wanted to use Access to clean data and provide excel sheets for the folks to udpate.

 

[SkipVought]

Hi,

In Excel, you can use Data > Validation - List on any cell or range of cells. You can reference a List Range, either using standard A1 reference, or Named Ranges, which will restrict values in the Data/Validation range to the valus in the referenced list range.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[mykd]

Hi Skip,

Thanks. The issue is with the output from Access. There are 3 columns which require input from the users. All three use the Lists / Combo box function. Unfortunately when the excel file is generated, the 3 columns are blank and dont show the lists of values for selection.

 

[SkipVought]

Are your lists not connected to queries? Use the queries to gen the lists.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}