Excel Import

I want to create an access database. Now from a query that I will be doing
every month from MySQL i will be importing an excel sheet. Now on this sheet
there will be usernames and ID numbers. These are for users in my office. I
want to create a second sheet that will be in the access database all the
time with the users employee number and other information. I want to when i
import this excel sheet for it to beable to reference that second sheet and
create a third sheet or report with instead of the users ID number their
employee number and some other info. I know this can be done just too long
since I have done it. Any help on this would be great. I am doing this to
keep track on monthly basis of vacation and sick days taken by employees.
Thanks in advance for the help.

What you would want to do is import the spreadsheet, into its own form, then
use a join (query) to combine the imported sheet with your existing table, to
produce the dataset you want.

Good luck.

Sharkbyte




"WisconsinIT" wrote:

I want to create an access database. Now from a query that I will be doing
every month from MySQL i will be importing an excel sheet. Now on this sheet
there will be usernames and ID numbers. These are for users in my office. I
want to create a second sheet that will be in the access database all the
time with the users employee number and other information. I want to when i
import this excel sheet for it to beable to reference that second sheet and
create a third sheet or report with instead of the users ID number their
employee number and some other info. I know this can be done just too long
since I have done it. Any help on this would be great. I am doing this to
keep track on monthly basis of vacation and sick days taken by employees.
Thanks in advance for the help.