Excel Import

[WisconsinIT]

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.

 

[Sharkbyte]

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