How are you going to link the payments to the people in ebase? Do you have
their record number in QuickBooks? That would be most reliable.
My guess is that the flat file will be easier to deal with than excel.
> -----Original Message-----
> From: Colin Cooler [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 10:13 AM
> To: TechRocks Support
> Subject: [support] QBPro 2001 Data Export
>
>
>
> 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
> ---------------------------------------------------------------------
>
>
------------------
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
---------------------------------------------------------------------
