Joe, Just have them send you the file as xxxx.csv, then look at it in your text editor. The first record will be the field names. Date,Check#,Description,Amount 01/05/2014,1234,Frivolous Purchases,345.15 01/07/2014,1235,More Junk,50.00 etc.
There will be lots of fields. Pick the ones you want and define a dbf, then import as CSV. Here's an example I did for the Contacts export from Outlook.com: create DBF CONTACTS (F1 C(1), FNAME C(15), F3 C(1), LNAME C(15), ; F5 C(1), COMPANY C(15), F7 C(1), F8 C(1), F9 C(1), ; F10 C(1), F11 C(1), F12 C(1), F13 C(1), ; STREET C(20), CITY C(15), STATE C(2), ZIP C(9), F18 C(1), F19 C(1), ; BPHONE C(15), F21 C(1), F22 C(1), F23 C(1), F24 C(1), F25 C(1), ; HPHONE C(15), F27 C(1), F28 C(1), MPHONE C(15), ; F30 C(1), F31 C(1), F32 C(1), F33 C(1), F34 C(1), F35 C(1), F36 C(1), F37 C(1), F38 C(1), F39 C(1), ; F40 C(1), F41 C(1), F42 C(1), F43 C(1), F44 C(1), F45 C(1), F46 C(1), ; EMAIL C(20)) select CONTACTS append from WLMContacts CSV index on Upper(LNAME)+Upper(FNAME) tag LNAME browse fields LNAME, FNAME, COMPANY, BPHONE, HPHONE, MPHONE, EMAIL ... then do whatever. Dan Covill > Date: Thu, 6 Feb 2014 14:46:59 -0500 > Subject: Automated bank/credit card transaction > From: [email protected] > To: [email protected] > > Most of the financial institutions I deal with have web sites showing the > current activity in my accounts. The sites allow exporting this data as > .CSV files. I would like to automate the download of this exported data > preferably from VFP code. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
