I am attempting to import a .txt file which has been exported from a mainframe dataset.
I am able to read the data and parse it correctly and in most cases I can then insert the details onto access tables.
I am having problems with some rows however - vba reports an error saying that the length of the data to be inserted is too big for the field. As I know the lengths are correct the problem is to do with the data. When I open the .txt file in notepad I can see just spaces however in textpad I can see a black line - attempts to copy/cut this item fail - reports that Null values cannot be copied.
I think the problem is that the mainframe file contains 'low value' hex 00. This for some reason is causing access to think that the item to be inserted is too big.
I was wondering can I use the replace command to change these 'characters' to spaces - if so does anyone know what I would be searching for because if I use " " then it will take forewer. The files has over 9000 rows with strings up to 10000 bytes and there are only a few examples of these 'characters'
I am able to read the data and parse it correctly and in most cases I can then insert the details onto access tables.
I am having problems with some rows however - vba reports an error saying that the length of the data to be inserted is too big for the field. As I know the lengths are correct the problem is to do with the data. When I open the .txt file in notepad I can see just spaces however in textpad I can see a black line - attempts to copy/cut this item fail - reports that Null values cannot be copied.
I think the problem is that the mainframe file contains 'low value' hex 00. This for some reason is causing access to think that the item to be inserted is too big.
I was wondering can I use the replace command to change these 'characters' to spaces - if so does anyone know what I would be searching for because if I use " " then it will take forewer. The files has over 9000 rows with strings up to 10000 bytes and there are only a few examples of these 'characters'