>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?
Sounds to me as if you asked Excel to open this file assuming an
incorrect delimiter. As you open the text file you are stepped
through a text wizard which asks, among other things, what the field
and text delimiters are. I expect that if you pick the right
combination the fields will be distributed correctly to separate
columns.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
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
---------------------------------------------------------------------
