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 ID.

 

I am however unable to upload any of the company and employee locations using their state ID’s and country ID‘s into access. When I try to upload them Into their tables the database will not read them and keeps the tables blank.

 

Can you please offer some help on how to troubleshoot and proceed. Thanks.

access
  • Woldman's avatar
    Woldman
    Iron Contributor
    Oct 21, 2020

    Bizkeeper 

    It would be helpful if you could share the table design for company and employee location, and examples of the Excel sheets containing the data

    • 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.

  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Steel Contributor
    Oct 21, 2020
    Could you please share some sample data which has been loaded and other which you are trying to upload,,, and one more are you trying to upload both in same table?

Resources