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?