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 comments.
Is there a way to have it either ignore any semicolons found in text file column range 266-315 and 317-366? Or, have access edit the file to replace those particular semicolons with a space/comma?
Thanks in advance!
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 comments.
Is there a way to have it either ignore any semicolons found in text file column range 266-315 and 317-366? Or, have access edit the file to replace those particular semicolons with a space/comma?
Thanks in advance!