TRNAMT = CCur(Mid(nextline, 10, Len(nextline) - 1)) * -1 I'VE REPLACED LESS-THAN WITH ' ThenįID = Mid(nextline, 6, Len(nextline) - 1)īANKID = Mid(nextline, 9, Len(nextline) - 1)ĪCCTID = Mid(nextline, 9, Len(nextline) - 1)ĪCCTTYPE = Mid(nextline, 11, Len(nextline) - 1) THE CASE STATEMENTS ARE LOOKING FOR LT AND GT SIGNS AND SOME OFX FIELD IDENTIFIERS. I GUESS YOU CAN'T PLACE CERTAIN CHARACTERS SUCH AS A GREATER-THAN SIGN IN A POST. QFX files into SQL Server.ĪDDENDUM: SORRY, I CANNOT POST THE CODE AS WRITTEN TO SQLSERVERCENTRAL. Here's some very simple, but effective VBA code for the import of Bank of America. OFX (QFX) files is available at:īank of America apparently uses version 1.0.2 for their files. Everything you ever wanted to know about.
