problems importing from Excel format

A place for discussion on how to use the program more effectively

problems importing from Excel format

Postby djklord » Wed Aug 08, 2007 2:06 am

I have my data in Access 2007. I can export to Excel 5.0/95 or Excel 97-2003.

When I export to 97-2003 format, DM complains just after I select the file to import saying, "Internal consistency error."

When I export to 5.0/95 format, the comment field is truncated to 255 characters, and I have comments longer than that. I'd prefer not to have to type or copy/paste those comments over from Access to DM. (I have about 700 records.)

I also have access to Access 2003 if that would help me any.

Any advice would be appreciated.
Dan Lord
Wycliffe Bible Translators
User avatar
djklord
 
Posts: 25
Joined: Mon Jul 17, 2006 10:15 pm
Location: West Chicago Illinois

Postby jmuehleisen » Mon Sep 03, 2007 12:38 am

Dan,

You are correct about about the limit on importing comments from Excel.

But, send me your Access file and I'll see if I can do a straight Access -> FoxPro conversion manually.

Send it to john@donormanager.com
John Muehleisen
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation
User avatar
jmuehleisen
Site Admin
 
Posts: 722
Joined: Sat May 29, 2004 1:28 pm
Location: Kampala, Uganda

Thanks for the offer

Postby djklord » Fri Sep 21, 2007 4:59 pm

Thank you, John, for the offer to convert my data for me, but I've already got the data from Access into Donor Manager and have now added several years' worth of giving data.

I think the number of records with comments over 255 characters long is not a large percentage of the total, and so will just re-type or copy-paste that extra data by hand.
Dan Lord
Wycliffe Bible Translators
User avatar
djklord
 
Posts: 25
Joined: Mon Jul 17, 2006 10:15 pm
Location: West Chicago Illinois


Return to Donor Manager Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron