Contribute to the Microsoft 365 and Office forum!

Click here to learn more 💡

Access Forum Top Contributors:

GroverParkGeorge - Tom van Stiphout - Ken Sheridan - Scottgem ✅

Ask a new question

RA

Alpha Five database

How can I move an existing Alpha Five V7 database into Access?

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Replies (4)

Daniel Pineault

MVP

Export your tables to Excel and then you can easily enough import them into MS Access. As far as everything else is concerned (forms, reports,...) you have to recreate them all from scratch. There is no way to import them.

That said, normally, even their table structure are not necessarily the best setup for MS Access. So I'd probably create my own normalized table structure and then use the imported data to populate my tables.

--
Daniel Pineault
Microsoft MVP 2010-2021

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

RA

Thanks but a bit of my problem is figuring out how to export to Excel. I have A5V7 and it doesn't appear to support that.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Daniel Pineault

MVP

Perhaps this could help http://www.learnalpha.com/Export/Export.htm

http://wiki.alphasoftware.com/Quick+Export+to+Excel+-+Action+Scripting

http://wiki.alphasoftware.com/Export+Operations

But aren't your dbs *.dbf, if so then you can directly read them in Access.

--
Daniel Pineault
Microsoft MVP 2010-2021

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

The last I recall, Alpha 5 used the DBF format, so you should be able to import using that format.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Question Info

Last updated January 24, 2022 Views 1,045 Applies to: