Excel will let you split a field on a certain character. Create enough empty fields
to accommodate all the data and then split the field on the quote
marks. Be sure to create more empty fields than you think you'll need - if you're
wrong you can lose data.
Barb Welch
Executive Director
Frenchman Bay Conservancy
Colin Cooler wrote:
> 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
---------------------------------------------------------------------
