other than vendor,customer, account numbers, I did not belive that Quickbooks allow for export - I create a report will all the information and then export it to Excel then to Rbase
J
At 09:33 AM 10/27/2005, you wrote:
Claudine and Albert, thanks for the information on QIF files. It looks like I will have to create my own import method. I was hoping that there was some easy/automatic way to convert to a format that is compatible with Gateway.
John
From: [email protected] [ mailto:[email protected]] On Behalf Of Claudine Robbins
Sent: Tuesday, October 25, 2005 3:10 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: QIF files
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 cant 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, youre 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
