'Const mksConnectionString = "Provider=.4.0 Data Source=M:\Programming\QIF\QIF.mdb" MsgBox "Import is complete!", vbOKOnly, "QFX File Import" MEMO = PQ(Mid(nextline, 7, Len(nextline) - 1)) NAME = PQ(Mid(nextline, 7, Len(nextline) - 1)) TRNAMT = CCur(Mid(nextline, 10, Len(nextline) - 1))įITID = Mid(nextline, 8, Len(nextline) - 1) 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.
#QUICKEN QIF FILE CODE#
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.
0 kommentar(er)
