Hello, would you help me?
I have a lot of data in excel and I want to export this information to Irricad database, how can I do it?
Can I open the Irricad database with Microsoft Access?
I installed Irricad version 16.06
Thank you.
Importing data from excel to Irricad database...
- Dan Crosby
- Site Admin
- Posts: 181
- Joined: Thu Apr 30, 2009 9:28 am
- Company: Lincoln Agritech Ltd.
- City / Town: Lincoln
- Location: Lincoln, New Zealand
- Contact:
Re: Importing data from excel to Irricad database...
Hello,
This is certainly possible using the Query tab in the database editor, but depending on the type of component data you wish to import, you may need some knowledge of how the database is structured in order to make it work.
You can open the database in Access but there are a couple of potential problems there:
Regards,
Dan
This is certainly possible using the Query tab in the database editor, but depending on the type of component data you wish to import, you may need some knowledge of how the database is structured in order to make it work.
You can open the database in Access but there are a couple of potential problems there:
- A lot of our databases are in Access 97 format. If you don't have Access 2010 or earlier, you won't be able to open such files.
- As above, direct editing in Access requires an understanding of how the database works and we don't usually recommend it.
Regards,
Dan
Dan Crosby
Irricad Developer
Lincoln Agritech Ltd