Page 1 of 1

problems importing from Excel format

Posted: Wed Aug 08, 2007 2:06 am
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.

Posted: Mon Sep 03, 2007 12:38 am
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

Thanks for the offer

Posted: Fri Sep 21, 2007 4:59 pm
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.