I belive QIF/QFX files are not records, but sequential fields with a
record break. I don't have a copy handy, but ran into them before. The
file structure is along the lines of
Record type
field 1
field 2
field 3
new record
field 1
field 2
field 3
end of file
Claudine Robbins wrote:
John,
http://web.intuit.com/support/quicken/2002/win/1181.html
I have never used QIF/OFX file formats, but I would start looking at
converting the data into a better known format such as ASCII, CSV or
XLS (search/replace for the field and record delimiters). I can’t tell
from this sample what the field delimiter is, but the file delimiter
is a caret. It appears you first have to manipulate the file format
then map a temporary R:Base import table to the import fields. Then,
you’re home free to append, insert or update the fields in your
permanent R:Base tables.
Hope that helps a little.
------------------------------------------------------------------------
*From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of *John
Engwer
*Sent:* Tuesday, October 25, 2005 1:17 PM
*To:* RBG7-L Mailing List
*Subject:* [RBG7-L] - QIF files
I have a client that wants to download checking account information
from a bank and import it into RBase.
Does anyone have experience importing QIF files to RBase?
If so, how do you do it?
John
