Consulting

Results 1 to 5 of 5

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

  1. 10-09-2023, 07:38 AM #1
    itsmasum
    itsmasum is offline
    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.
    Reply With Quote Reply With Quote
  2. 10-09-2023, 11:16 AM #2
    June7
    June7 is offline
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    337
    Location
    Review https://answers.microsoft.com/en-us/...c-dd20d23e8d06
    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.
    Reply With Quote Reply With Quote
  3. 10-11-2023, 12:11 AM #3
    troywolf
    troywolf is offline
    VBAX Newbie
    Joined
    Oct 2023
    Posts
    1
    Location
    Quote Originally Posted by June7 View Post
    Review https://answers.microsoft.com/en-us/msoffice/forum/all/import-or-link-to-bloxd io-google-spreadsheets-simple/9cd275e0-8006-433d-923c-dd20d23e8d06
    I like this solution, but I don't understand "Set up Google drive so documents had a path in my local computer."
    Reply With Quote Reply With Quote
  4. 10-11-2023, 01:48 AM #4
    June7
    June7 is offline
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    337
    Location
    Maybe this https://www.cnet.com/tech/services-a...uments-folder/
    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.
    Reply With Quote Reply With Quote
  5. 12-25-2023, 07:19 PM #5
    ternfs121
    ternfs121 is offline
    VBAX Newbie
    Joined
    Dec 2023
    Posts
    1
    Location
    Quote Originally Posted by June7 View Post
    Maybe this https://www.cnet.com/tech/services-a...uments-folder/
    thank you!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules