For anyone well-versed in OpenOffice Base and MS Access

[ironduck]

I'm looking to migrate a database from Microsoft Access to OpenOffice Base. The reason is that the user is switching to Mac, which doesn't have Access.

I originally created the Access database (which is just a form of about 30 fields, many of them drop down menus to select from various options).

I really dislike working with databases.

I've tried to figure out how to convert it in an easy manner and have gotten a little help here and there on the OpenOffice forum, but it still caused me a lot of headaches trying to get it to work. I really don't want these headaches if I can avoid them.

I figure that for someone who is used to this stuff it's fairly easy to rebuild the form in OpenOffice. I don't need it to look fancy, just in the proper working order, then I can polish it myself. I will also need step-by-step instructions on getting the original data transferred into the new database.

I'm offering $50 US for anyone willing to do it. This assumes you know what you're doing, I can't use something that isn't working properly. It is, however, a simple base with nothing complicated. If I was into databases I could set it up in about an hour.

If you're interested just ask here or send a pm. It's easiest for me to pay via Paypal.

 

[warpus]

I'm not familiar with OpenOffice Base at all, but it should be very easy to transfer the data itself.

Export the data to a CSV file (comma seperated values) - OpenOffice Base will likely support the import of such a file.

That's the easy part - the form itself might have to be totally re-done from scratch. Although don't take my word for it - there might be a conversion tool available!

 

[ironduck]

Yeah, it shouldn't be too hard to transfer the data, I just figured that if someone wanted to build the form they would be able to walk me through it to make sure it worked out. I can't just send the full thing over for someone to do because it's confidential patient info.

 

[Paalikles]

Perhaps you should take this to "Computer talk"?

 

[ironduck]

Didn't see such a forum existed.. if the mods think it should be moved, feel free to.