problems importing from Excel format

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

Post Reply
User avatar
djklord
Posts: 26
Joined: Mon Jul 17, 2006 10:15 pm
Type the middle number, please (202): 302
Location: West Chicago Illinois

problems importing from Excel format

Post by djklord »

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
jmuehleisen
Site Admin
Posts: 737
Joined: Sat May 29, 2004 1:28 pm
Type the middle number, please (202): 202
Location: Kampala, Uganda
Contact:

Post by jmuehleisen »

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
djklord
Posts: 26
Joined: Mon Jul 17, 2006 10:15 pm
Type the middle number, please (202): 302
Location: West Chicago Illinois

Thanks for the offer

Post by djklord »

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
Post Reply