Recent content by TeeJay

We are working on that but the files come from an outside source on a daily basis so, until the fix is in place at their end they will still be in this dodgy format.

No. The csvs are comma delimited but for some reason some of the records within each file are output with ~ instead (the example in my first post is from one file, note the comma delimited rows and rows with ~ in) also, because the individual fields are not encapsulated within their own set of...

they are .csv's I discussed that with someone who knows a bit more about VBA than I do, but he reckons that would just cause issues with the comma delimited fields (they're coming in via the same files as the ~ delimited fields, which is why I'm having such a problem).

Hi, I am completely new to VBA (never used it before) and I've come up against an issue that I just can't figure out. I have an access table that looks like the below: "field1", "field2, field3, field4, field5, field6, field7" "field1~field2~field3~field4~field5~field6~field7"...