Consulting

Results 1 to 5 of 5

Thread: How to sync an access table with google sheets.

  1. #1
    VBAX Newbie
    Joined
    Oct 2023
    Posts
    1
    Location

    How to sync an access table with google sheets.

    hello everyone.
    I have a dental clinic management database made in access. And I have an IoT project that can display data from a google sheet. i want one of my access table to be always in sync with that google sheet as i want to display it in the IoT project screen. it's only a couple of rows and coloumns. i tried codes from chatgpt using google api key. tried google form response id. nothing seems to work. can you help me with it? thanks.

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    348
    Location
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    VBAX Newbie
    Joined
    Oct 2023
    Posts
    1
    Location
    I like this solution, but I don't understand "Set up Google drive so documents had a path in my local computer."

  4. #4
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    348
    Location
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Quote Originally Posted by June7 View Post
    thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •