Our organization just upgraded to QuickBooks Pro 2001 (from an earlier
version). The latest version lets you produce a report from which you can
export transaction data (such as checks received) to either an Excel
spreadsheet or an ASCII text file.
I'd like to import this historical payment data from Excel into the Payments
file. Unfortunately, the Excel file that results has all the fields placed
in a single cell within the spreadsheet and quotes around each field data
within that cell. (Don't you just know Intuit deliberately made this
difficult!)
Is there any way to strip out the quotes and place each field in a separate
cell (column) so that I can import this directly into ebase?
If necessary, I could wrestle with "IIF" format (but I know nothing about it
at this point or how to get more detailed info on it).
TIA
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
