import from excel

[Derek Atkins]

George OLson <grglsn765 at gmail.com> writes:

> On 11/08/2011 04:32 PM, Geert Janssens wrote:
>>>
>> You could try to save your excel sheet as a CSV file (comma separated values)
>> and then use the CSV importer in GnuCash.
>>
>> Geert
>
> Ok, that is a good idea. I did that and it works. However, the
> transfer field does not import, and there seems to be no mechanism for
> including the transfer field in the import. Does anyone know of a way
> to set the transfer field?

I dont think there is a way to do that in the CSV importer.  You could
try the Calc2QIF macro to convert your excel to QIF, which does have a
way to import transfer account info via QIF Categories.

> George

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available