QIF Conversion

[simon1974]

I would like to create a small application in Access that will track credit card and banking transactions. I want to enable users to import qif files from various institutions. Does anyone know of a VBA routine or ODBC definition that will allow import of the QIF "record after record" file format neatly into an Access table? Thanks for any help you can provide

Sean
seansimoncpa@yahoo.com

 

[smedvid]

You most likely need to build you own... I've created custom import/export of EDI-820... Just need to validate all fields and proper layout... htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[simon1974]

smedvid, thanks for your post. What VBA functions are useful in reading in the continuous record after record format of EDI/QIF? I'm not sure where to start.

Thanks

 

[smedvid]

Honestly, the methodology I employed was to bring the entire EDI file into a single field table where the field is CHAR(255). Then I loop through the table row, by row, via a RecordSet. Depending upon various conditions and defined positions, I know what data should reside in certain designated positions. I use the MID() then to extract the individual piece into useful information. Don't give up; there may be canned products and/or libraries that offer this ability. However, in my case, I never researched them due to budget constraints and requirement for flexibility. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...