I have a gigabyte worth of CSV files that are delimited by the | symbol. The problem I have is that some of the records are posing a problem since there are double quotes contained within. The only solution I am able to find is to manually change the records, which is rather impractical for me.
Is there some way of telling Access to disregard them? Or possibly another solution?
Bookmarks