Syncing Phone Contacts with Database Table

Question

I would like my phone's Contacts to sync with my contacts in my Access database contacts table

but I'm not sure how to go about this.

I only add or edit contacts using my phone so my Contacts table and the phone list don't match exactly.

(Although they are close.)

My cheap phone only explains how to do this using Googe Contacts to sync.

Should I sync my phone contacts with Google contacts then export the list to a .csv and then import into Access?

Answer 1

If this is going to be a repeated operation, then you can automate it and repeat the steps needed so that you only have to do it once.

Step One.

Import the csv into a temporary table in Access. This creates a template for future imports that can then be replicated.

Step Two.

Create a query based on that temp table. Include in that query only the fields you want to keep. The first time you run, you can run it as a Make Table query to create the permanent, production table if necessary. Or, if you want to update an existing table, you can use it that. Or, if you want to append new records, you can also do that.

Step Three.

Delete the records from the temporary table in preparation for the next import.

Step Four.

You can, if you want, put each of these steps into a VBA procedure which can be called from a command button on a form.

Answer 2

I was able to import the csv to a blank table. The only thing is it took way longer than expected.

Thew problem was that the export has nearly 90 fields. I needed remove the unwanted fields

in the table which took some time.

There must be a better way.

Answer 3

That is probably the least painful way to synch the phone contacts with the Access relational database application.