problems importing from Excel format
Posted: 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.
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.