This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C1E480.65537680
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

I have some code which reads a text file line by line into an array. 
This is then inserted into a access table. text file is an excel 
formatted csv file. Is there the chance that the format type of the text 
file can affect the readability of the text strings by access. At 
present it will not accept the array value that represents the foriegn 
key of the table so gives me the error message that a recordis required 
in the parent table, even though it is there and the two are identical.

Am using iis5, wsh, ms access,

Thanks

Andrew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "AAustin" <plant-tech@x...>
Subject: [access_asp] arrays


: I have some code which reads a text file line by line into an array.
: This is then inserted into a access table. text file is an excel formatted
: csv file. Is there the chance that the format type of the text file can
: affect the readability of the text strings by access. At present it will
: not accept the array value that represents the foriegn key of the
: table so gives me the error message that a recordis required in
: the parent table, even though it is there and the two are identical.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

How do you know the two are identical? (ie how did you test this?)

If you did not test this, how about you loop through both strings and output
the ASCII values of each character in the string. You may have some
non-visible characters (eg one might be a NULL terminated string or
something).

Cheers
Ken