Access Error importing data from Lotus Notes
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 13, 2009 6:26 PM
UPDATED:
January 15, 2009 12:54 AM
RELATED QUESTIONS
- Problems oprning Excel File
- Lotus Missing Archive Folders
- How to access my boss personal address book when I am using vs6.5 and she is using vs8.5
- When a database has been open for an extended amount of time and when you finish fillling out a form and click save a message appears stating Frameset *** does not exist
- Opening Lotus Notes .NSF files
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
