I'm appending data to a linked text file in Access 2002 with an Append Query. The appending works ok, but numbers are truncated to two decimal points. I've tried changing the table parameters in the link dialogue and have tried different number formats in the query, but in each case, the numbers are truncated. Is there a way to append with more than two decimal points.