Approcah to Access
- Thread starter Puddy
- Start date
Nero
Shop smart, shop S-Mart
- Local time
- Today, 03:17
- Joined
- Jan 8, 2002
- Messages
- 217
I had this problem a while back.
What I ended up doing was importing all the Lotus tables into Access. I think I used DBase5 as the import option but I can't be certain now. Then I rebuilt the forms from the imported tables.
Most of the data imported OK but it did need a bit of formatting.
I still had to rebuild theforms but at least the data was intact.
What I ended up doing was importing all the Lotus tables into Access. I think I used DBase5 as the import option but I can't be certain now. Then I rebuilt the forms from the imported tables.
Most of the data imported OK but it did need a bit of formatting.
I still had to rebuild theforms but at least the data was intact.
mdemarte
Computer Wizard
- Local time
- Today, 03:17
- Joined
- May 8, 2001
- Messages
- 138
import Lotus db to access
I have been doing quite a bit of this. First, I import the database table to Access. Check the formats. Then, rebuild the rest (forms, reports, macros, queries). I carefully print all of the stuff I can from Lotus and make notes to use for the convert. It takes a while, but I have been able to convert and use all of my good data (if someone deleted the parent record and the child record is still there, then I have orphan records). Good luck.
I have been doing quite a bit of this. First, I import the database table to Access. Check the formats. Then, rebuild the rest (forms, reports, macros, queries). I carefully print all of the stuff I can from Lotus and make notes to use for the convert. It takes a while, but I have been able to convert and use all of my good data (if someone deleted the parent record and the child record is still there, then I have orphan records). Good luck.
