If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending column with different data type
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? |
#2
|
|||
|
|||
Appending column with different data type
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. JoeA2006 wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200611/1 |
Thread Tools | |
Display Modes | |
|
|