Procedure query writes wrong values - HELP

[tranchemontaigne]

I'm trying to use a procedure to write phone numbers to a text field and unable to have the phone number post correctly. Duplicating the query in the pure query environment writes the wrong value to the table too.

Here is the SQL as simplified as it can be to duplicate the behavior

<code>
INSERT INTO
t11_FoodBusinessInfo_Local
(
[EstablishmentTelephone#]
)
VALUES
(
"6036435711"
)
;
</code>

yet

"6036435000"

is the value written to the table. Note how the last 3 digits have been replaced with zeros. For testing I tried writing the phone number as a single into a single field (avoiding the text data type altogether) and observed that the last 3 digits of every phone number passed through the procedure were also replaced with zeros.

Problem has been duplicated on more than one computer.

I'm not sure how to resolve this but any assistance would be appreciated.

My environment is MS Access 2000 SP3 on Windows XP.

 

[tranchemontaigne]

UPDATE: I changed table field data type to a number again, saved, then back to a text and the problem appears to have gone away....I have no idea why this appears to have worked.