Error 3349 when Using TransferText into Linked Table

[J Harkins]

In Access 97, I set up a linked table as a repository for
fields from an imported, fixed-length TXT file. The
technique worked perfectly.

In Access 2002, it's as if TransferText is trying to read
beyond the end of the file, as it stops and gives me an
error on a record number one greater than the number in
the original TXT file.

I think there are actually two problems:
(1) the "extra" record with no data and
(2) the failure with a 3349 error code (numeric field
overflow) when trying to stuff the imported records into a
linked table.

I hate to say how long it took me to find out that there
was a difference between trying to stuff the data into a
regular table or a linked table.

Hope you can help.

Thanks,

John

 

[John Nurick]

Hi John,

In Access 97, I set up a linked table as a repository for
fields from an imported, fixed-length TXT file. The
technique worked perfectly.

In Access 2002, it's as if TransferText is trying to read
beyond the end of the file, as it stops and gives me an
error on a record number one greater than the number in
the original TXT file.

I think there are actually two problems:
(1) the "extra" record with no data and

I haven't had this happen myself, but it does seem that Access 2002
seems a bit more particular about textfile formats than Access 97. So
I'd look out for a blank line at the end of the textfile, or indeed for
any other irregularity in it.

(2) the failure with a 3349 error code (numeric field
overflow) when trying to stuff the imported records into a
linked table.

Could this just mean that the linked field is Number(Integer) and you're
trying to append values greater than 32767 or whatever it is?

I hate to say how long it took me to find out that there
was a difference between trying to stuff the data into a
regular table or a linked table.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.