Append Query - Number to Text

[Guest]

I have a query that imports data from a CSV to another table .. once the
table is created then relevant columns are transferred to other tables using
the Append Query Function.

Initially imported data is in a number Format however after the append query
this changes to a text Format, Can I force the append to copy/append the
values as numbers ??

Many thanks

 

[John Spencer]

Are you appending to tables that are already created? You normally should
do so. If you are using a "Make Table" query to do this then you may be
able to solve the problem by using the conversion functions to force the
data type.

Perhaps you can post the SQL of one of your queries.