Recent content by rkane

Don't think that approach would work to be honest. Here's one of the error lines that I get: The ; after CREDIT ALL is the excess. Keep in mind that this is all one line, and it looks like it removed some excess spaces when I pasted it (line length is 403 characters).

I guess I should clarify. The columns I was referring to when talking about the 266-315 and 317-366 is the character reference in Notepad. IE Ln 26, Col 366. The source is a text file that our system sends to a network folder. This is a case where the "download" was setup to capture data...

Hello All! I am having an issue with trying to import a semicolon delimitted text file with 52 columns into a table. I am utilizing a piece of vba to parse through the file, however there are a pair of comment fields in the text file, and sometimes people are using semicolons in their...