Appending column with different data type

[Guest]

I need to append rows from a query to a table and then export this data to
Excel.
I would like to be able to sum the columns with a macro in Excel. The
problem is I have columns in the query which contain numeric values that need
to be appended to columns that are text in the table(I assume it is because
they are null ). When I change the table design for these columns to
currency, Access will not append the records. I created columns with no data
Column1'') so I could have a column to append records to, because the table
has columns not in the query and the vice versa.
Is there a way to accomplish this?

 

[kingston via AccessMonster.com]

Revert back to your original table design so that the export works. In Excel,
add a column that multiplies the original field by 1; this will convert the
data to a number. Modify your macro to work on the new calculated column.
You can hide the additional column so the change is transparent to the user.