Re: "Numeric->Text" Type conversion in "Make Table" Query

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 04:42:53 -0700

Don't use a Make Table -- Access gets to decide on field types.

If you use an import table, consider that only a "staging area". Write
queries that force a conversion to the proper data types, and append the
data into your set of "final" tables. 

-- 
Good luck
Jeff Boyce
<Access MVP>