I have written a VB6 application that reads in a fixed length text file and populates a MS SQL Server database with the information. Below is the command I use to read the file:
Open Projects_File For Input As #1
Do Until EOF(1)
Input #1, mWork_String1
...(process the records)
Periodically, the input text file has a comma in one of the fields and when that happens, everything from the comma on is ignored - not read in. I don't understand why that happens in a fixed length file. I can see commas causing a problem in a .cscv input file, but this is a fixed length file.
Anyway, the mWork_String1 variable never receives any data after the comma and that means I am dropping data.
This is causing problems with importing of the data. Does anyone have any idea about how to fix this problem? Any work-around?