Access Error importing data from Lotus Notes

5 pts.
Tags:
Access and Lotus
Lotus Notes
Lotus Notes import/export
Microsoft Access
Microsoft Access import/export
I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I've already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does the exports to Lotus 1-2-3 works fine Opens Microsoft Access opens the database Does File --> Get External Data --> Import Changes the File Type to Lotus 1-2-3 Clicks on MLPC.wk3 then clicks Import Gets this error message Microsoft Access has encountered a problem and needs to close. We are sorry for the incovenience. The information you were working on might be lost. Microsoft Access can try to compact and repair your open database x Repair my open database and restart Microsoft Access. Please tell Microsoft about this problem. We have created an error report that you can send to help us improve Microsoft Access. We will treat this report as confidential and anonymous. To see what data this error report contains, click here Any ideas or suggestions?
ASKED: January 13, 2009  6:26 PM
UPDATED: January 15, 2009  12:54 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Long shot answer … I am not sure if this will work.
Access database is terribly inefficient in data space management. You may try to compress the database before attempting the export. In Access 2007– “Compact and Repair database” is under the Office button – then Manage. I think it in 2003 – it is under Tools. Be sure to give a new name to the compressed database & then try the export. It will be interesting to know the final solution.

Try import into new empty Access DB.
Try export from Lotus into Access.

Try opening the Lotus 1-2-3 file in Excel and examine the data. I have received this error during an import into Access from Excel or CSV when the data has something unexpected.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following