Forum Discussion

Bizkeeper's avatar
Bizkeeper
Copper Contributor
Oct 20, 2020

Problems uploading State and Country ID’s

Hello All,   I have successfully uploaded all my company contacts and their employees via excel spreadsheet into their respective tables in access using each company ID and each individual employee...
access
Bizkeeper's avatar
Bizkeeper
Copper Contributor
Oct 22, 2020

Woldman Thanks for your response please see the attached database sample along with the spreadsheet. if you open the database you will see a list with state ID's and Country ID's, these will need to upload to the table listed as "Location Details" in order to generate the state and country into the database, but it is not working. 

Bizkeeper's avatar
Bizkeeper
Copper Contributor
Oct 22, 2020

@Tieme Woldman Im sorry i seem unable to upload a copy of the access database can you please advise how to do so.

  • Woldman's avatar
    Woldman
    Iron Contributor
    Oct 22, 2020

    Bizkeeper 

    We're not allowed to upload Access databases, but maybe you can make print screens of the (Access) table definition(s) and share it here.

    • Bizkeeper's avatar
      Bizkeeper
      Copper Contributor
      Oct 23, 2020

      Woldman Here are some screen shots of the location detail table along with the list of state and country ID's.

      • Bizkeeper's avatar
        Bizkeeper
        Copper Contributor
        Oct 30, 2020

        @Tieme Woldman Hi Can you please let me know your thoughts? Thanks! 🙂

Resources