From: John W. Vinson on
On Mon, 26 Apr 2010 19:06:01 -0700, joemeshuggah
<joemeshuggah(a)> wrote:

>maybe i dont understand, but if the issue stems from a linked text file, the
>datatypes cannot be changed....when i try to go into design view it does not
>allow the change since it is a linked text file and not a table

You'll need to use the import wizard to specify the datatypes of the fields,
then; if you just do a blind import Access will see what looks like numbers in
the file and (incorrectly) guess that the fieldtype is number. You will need
to create an Import Specification. It's tedious but not too difficult - use
the Advanced button on the import text wizard.

John W. Vinson [MVP]