accessdummy
Registered User.
- Local time
- Today, 21:32
- Joined
- Sep 7, 2003
- Messages
- 44
Hi guys,
pertaining to the earlier post, http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=218772#post218772, i have another few more burning questions which I need help.
I have many excel lists to be imported and all these lists are of different headings.
So after I import these lists into different tables, I need to extract 3 fields out to generate reports.
There are duplicates records existing in the various tables, e.g: table A has record XXX which table B has too. So how should I 'remove' the duplicate record?
Second, some of the excel list has running serial number 1 - 100, but some don't have. Hence when I import my lists, I have primary key assigned to the running serial number.
In order to standardise among all the imported lists-changed-tables, I assigned primary key to a field known as social_security.
However, Access prompts me that "Index or primary key cannot have null value" despite there are data in the field. How to resolve?
Thirdly, I built a query and used the union select command to extract the neccessary fields from all the existing tables (imported from excel) I need to generate report. By right, union command should remove duplicates, how come I still have duplicated records?
Note that the existing tables which I have imported (excel lists) are non uniform. That means to say they are not done up the same way.
pertaining to the earlier post, http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=218772#post218772, i have another few more burning questions which I need help.
I have many excel lists to be imported and all these lists are of different headings.
So after I import these lists into different tables, I need to extract 3 fields out to generate reports.
There are duplicates records existing in the various tables, e.g: table A has record XXX which table B has too. So how should I 'remove' the duplicate record?
Second, some of the excel list has running serial number 1 - 100, but some don't have. Hence when I import my lists, I have primary key assigned to the running serial number.
In order to standardise among all the imported lists-changed-tables, I assigned primary key to a field known as social_security.
However, Access prompts me that "Index or primary key cannot have null value" despite there are data in the field. How to resolve?
Thirdly, I built a query and used the union select command to extract the neccessary fields from all the existing tables (imported from excel) I need to generate report. By right, union command should remove duplicates, how come I still have duplicated records?
Note that the existing tables which I have imported (excel lists) are non uniform. That means to say they are not done up the same way.
