Check into the "Data\Text to Columns" command in
Excel. You can convert a single column into multiple
columns using the "delimited" option. You'll have to
tell it to use the quote character as the delimiter
and to treat consecutive delimiters as one...hope this
helps.
--- Colin Cooler <[EMAIL PROTECTED]> 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
>
---------------------------------------------------------------------
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
------------------
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
---------------------------------------------------------------------
