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.
problems importing from Excel format
- 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
Dan Lord
Wycliffe Bible Translators
Wycliffe Bible Translators
-
- Site Admin
- Posts: 737
- Joined: Sat May 29, 2004 1:28 pm
- Type the middle number, please (202): 202
- Location: Kampala, Uganda
- Contact:
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
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
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation
- 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
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.
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
Wycliffe Bible Translators