I'm having some trouble with importing some information from a delimited text file into an SQL database. I made a DSN for the file using the Microsoft ODBC driver. It reads most of the data fine. I can get most of it into the database, or using Excel
I can display it in a table.
This is a regular text file, the delimiter is a "|" character. Some of the data has double quotes embedded in it. Every time it hits one of these double quotes, the rest of the information on that line are ignored.Then it will move on to the next
line in the file.
Is there a way to set up the driver to read these quotes somehow, or to just ignore them?
View Complete Post