MS Access as data source

Koichi_Tsuji · 05-22-2019 07:42 PM

Is there any way to make Microsoft access file source for AppSheet? For instance , placing on one drive or google drive then connected to it?

Steve

Doesn’t look like it.

Bellave_Jayaram

If you are going one way - i.e., from Access to App, then you could export the data to a Gsheet.

If you need to go both ways - i.e., from Access to App and App to Access, then you could export the data to a Gsheet, manipulate it in the App, export whatever data you need to update in Access as CSV and import that into Access. I have a client who is set up to use this configuration.

If you use a MySQL database in the cloud, you can directly connect that to your Access database - I have a client who is currently doing this.

Koichi_Tsuji

Thank you for sharing your experiences. My client need to keep using existing ms access file, but we need to share this db with appsheet. After googling, it seems to be most feasible solutions that we export the access DB to sql and make a link to table in access backwards. Thank you again, will try this out.

Tsuji

Bellave_Jayaram

You are welcome.

Peter_Bernsen

Did you have implemented the solution? My client also wants to migrate and work now with 20 people in this Access database.

Koichi_Tsuji

Project I mind at that time the post was made didn’t happen after that so nothing happened with us.

pbabis

check out the CDATA site. It has a cost though, don’t know how much.

Allen_Jacques

I have exported MS access to google docs and connected it to AppSheet, then I created the UX/Slices, etc. They had many tables with many large tables so modifying the structure was not in the plan, i had to do some though but appsheet was able to do everything i needed to replicate in MS Access. They as well had one-to-one and one-to-many table relationships. I have gotten it all working, it took me several months as I had to learn AppSheet as well. Now we are adding new functionality that is not possible in ms access. AppSheet is not ideal (imho) for large forms except to use tabs or dashboards. Many related tables is impossible to see in the spec though which is not ideal. I had to be careful with the queries not slowing down the app with such large tables. We are pleased how quickly it opens and the inherent improved functionality 🙂 Definitely a BIG upgrade from MS access! 🙂

Home screen of App

Home screen

Data Spec 😞

data spec