Problems uploading State and Country ID’s

%3CLINGO-SUB%20id%3D%22lingo-sub-1801018%22%20slang%3D%22en-US%22%3EProblems%20uploading%20State%20and%20Country%20ID%E2%80%99s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801018%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20successfully%20uploaded%20all%20my%20company%20contacts%20and%20their%20employees%20via%20excel%20spreadsheet%20into%20their%20respective%20tables%20in%20access%20using%20each%20company%20ID%20and%20each%20individual%20employee%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20however%20unable%20to%20upload%20any%20of%20the%20company%20and%20employee%20locations%20using%20their%20state%20ID%E2%80%99s%20and%20country%20ID%E2%80%98s%20into%20access.%26nbsp%3BWhen%20I%20try%20to%20upload%20them%20Into%20their%20tables%20the%20database%20will%20not%20read%20them%20and%20keeps%20the%20tables%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20offer%20some%20help%20on%20how%20to%20troubleshoot%20and%20proceed.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1801018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1802063%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20uploading%20State%20and%20Country%20ID%E2%80%99s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1802063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F829638%22%20target%3D%22_blank%22%3E%40Bizkeeper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20helpful%20if%20you%20could%20share%20the%20table%20design%20for%20company%20and%20employee%20location%2C%20and%20examples%20of%20the%20Excel%20sheets%20containing%20the%20data%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1802187%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20uploading%20State%20and%20Country%20ID%E2%80%99s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1802187%22%20slang%3D%22en-US%22%3ECould%20you%20please%20share%20some%20sample%20data%20which%20has%20been%20loaded%20and%20other%20which%20you%20are%20trying%20to%20upload%2C%2C%2C%20and%20one%20more%20are%20you%20trying%20to%20upload%20both%20in%20same%20table%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1806454%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20uploading%20State%20and%20Country%20ID%E2%80%99s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1806454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20response%20please%20see%20the%20attached%20database%20sample%20along%20with%20the%20spreadsheet.%20if%20you%20open%20the%20database%20you%20will%20see%20a%20list%20with%20state%20ID's%20and%20Country%20ID's%2C%20these%20will%20need%20to%20upload%20to%20the%20table%20listed%20as%20%22Location%20Details%22%20in%20order%20to%20generate%20the%20state%20and%20country%20into%20the%20database%2C%20but%20it%20is%20not%20working.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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.

8 Replies
Highlighted

@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

Highlighted
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?
Highlighted

@Tieme 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. 

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted