Comments - import
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
What is your question? Are you trying to import an MS Access DB into MariaDB and failing, or are you just interesting in learning how to do it?
There are several utilities out there which import MS Access databases in to MySQL. I have never used any so I don't know how good (or bad) any of them are.
MS Access can also be used as a front-end for MariaDB by connecting via ODBC. This would be a good way to transfer data (probably not as good as using a dedicated transfer app), but again, I've never tried it.
Yes, I was wondering how to import MS access to maria. But apparently, I need all kinds of help.
First of all, I'm confused about Askmonty. Is there a way to search thru the current knowledgebase (without making a new posting)? I'm not seeing it.
Second, I did import a couple tables of mine the simplistic way (convert to csv and transfer). If there is a better way, I'd be interested.
Third, after moving these tables my app is extremely slow. I am using PHP and accessing Maria db thru the 32 bit ODBC drivers. I have 32 bit PHP installed because I used access and it only has 32 bit drivers. However, MS access is blazing fast compared to the same script on Maria db.
You should probably be using the PHP MySQL connector instead of ODBC.
As far as searching the Knowledgebase, there's a search box at the top of every page on the right-hand side.
Good luck!