import existing excel data in new access table

[bb]

Hi,
I have a problem.
I have some existing data in Excel sheets. For each employee I have one
Excel sheet with dates and various results per date.
now I have tables in Access in wich I want to import data from the
Excel sheets. In my Access table the field employee is an look up
table. Also the date field is an look up table.
now is my question how to import these data from Excel into Access with
holding the information per date (a look-up table) and employee (a look
up table).
I would appriciate if someone could help me out with this.
Or could point me to a existing topic on this.

Thanks in advance, Bernadette

 

[Ken Snell [MVP]]

I recommend that you import the data from one sheet into an ACCESS table.
Then you'll need to devise and run various append queries to copy the data
into the correct tables, and in some cases to replace a value with the value
from a lookup table. Doing this is a bit of an "art" and depends entirely on
the table/data setup of your database.

 

[bb]

Thanks,
and can you tell me how I should run those append queries? And how to
put some "art" in this?
Bernadette

 

[Ken Snell [MVP]]

Without knowing something about your data, I really can't give you any
specific suggestions. Some generic steps are
-- fill the parent tables first so that you'll have the values for the
linking fields in the children tables
-- fill the children tables "one step" down from the parent table next
-- continue until all children tables are filled

Append queries are just SELECT queries with an added clause to INSERT INTO
the new table name. ACCESS QBE window makes this fairly easy to design.

 

[bb]

Thanks again. Later this day I will try all the suggestions given.
I will let you know if I was able to implement it.

 

[bb]

Thanks for the idea. I went looking into the group about the calender.
http://allenbrowne.com/ser-51.html
I've found this website in a topic about implementing a calender. I
will try to use it.
Or do you have a better suggestion?

 

[bb]

Thanks, I will try this.
The adding of a calender I've looked for. I see a topic about that that
points to this website.
http://allenbrowne.com/ser-51.html
I will have a look overthere also and see if I can implement this.