Text file import truncated at null character

[jimlee]

Hi,

I have a text file which contains a null character which when trying to import into the database causes all the data after this character to be truncated.

I am trying to automate a process which will import this every day and the null value will always be there.

Please could someone suggest a way of either accepting the null values into the database without truncating them or getting rid of the null values from vba code before the import.

I have tried allsorts (opentextstream etc) but everything I can think of involves opening the file in some way first and then it's too late!

Any help much appreciated as always.

jimlad

"There's this thing called being so open-minded your brains drop out." - Richard Dawkins

 

[jimlee]

oops, wrong forum sorry. I've reposted in Microsoft: Access Modules (VBA Coding) forum.

jimlad

"There's this thing called being so open-minded your brains drop out." -