importing excel files to access

[NTxp]

hello everyone,

i am a journalist. i wanted to create a namebased databank for my archive.
years ago i started to collect names
i have a book/document contains names and pick up the names, entering the all names in excell format in 4 columns

name
surname
who
which page

for classify i am giving the title of the book to excel file

i entered 55 books i mean i have 55 excel files (total 32.000 names-by the way what is the limit of access)

i could not manage to import these excel files to access
i had the following problems

a person may appear in 6 different books
a person may have different titles (like dr, german, veteran)
a person may have exacly same name with the other person
do you have any access template i can use for namebasing

how can i prevent the problems
what do you suggest me

thanks everyone

best regards

 

[CJTyo]

Well, if you're aren't specifying a primary key in your main table you should be able to import the information. How did you lay out your table?

C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.

 

[NTxp]

hi,
thanks for your kind interest
problem is; i tried to collect my all excel files in a access file but i couldn't managed
if you think not to specifying a primary key cause the problem i'll do that

thanks

 

[CJTyo]

If you had duplicates of everything, which it sounds like you do, then the primary key is most likely causing the issue IF it's something like the persons name or some other piece of imported data.

It would help to know how you're trying to import the data - using it to make tables? putting it in tables you already made?

Access has a 2-gig space limit, I think that's it, not a record limit (like Excel).

C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.

 

[NTxp]

hi CJTyo,
thanks for your attention
the problem has duality faces

we have JOHN SMITH.
he is a soldier and mp (i mean he seems a soldier in book1 and seems senator in book 2)
preventing this looking:

john-smith-soldier-book1pg.23
john-smith-senator-book14pg.67

(i mean is there any chance for merging like that)

john-smith-soldier/senator-book1pg.23/book14pg.64

in additionally

we have one more JOHN SMITH (or more) but he is no corelation with the previous one, he is farmer
how can i distinct them?

i hope i can describe my problem

thanks again for your kind interest

 

[CJTyo]

You're going to need more information, some way of identifying in advance which JOHN SMITH is the same and which is not. It wouldn't be difficult to import your data into Access tables allowing duplicate entries, but tying different ones together like you want will be very tough unless you already have some way that they're linked or some other field that can be linked.

The "look" of the data, with the dashes, happens independent of the tables and data storage. You can format it to look however you want in reports and forms.

Is there something that ties certain people to others or is it just something you know in your own head?

C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.

 

[NTxp]

dear CJTyo
many thanks for your kind attention