Exporting / or copy to Excel
 

Hi:

How can a I export or copy an Access query result to Excel (always the same
columns) and keep the formula that I have originally in Excel; so: to have in
col X, for example M2*2 before the col X is populated??

Any help is appreciated!

Thanks,

Dan

Exporting / or copy to Excel
 

1. save the formulas in column X to an un-used column
2. perform the export to Excel
3. restore the formulas from the un-used column back to column X
--
Gary''s Student - gsnu200752


"D" wrote:

Hi:

How can a I export or copy an Access query result to Excel (always the same
columns) and keep the formula that I have originally in Excel; so: to have in
col X, for example M2*2 before the col X is populated??

Any help is appreciated!

Thanks,

Dan