Importing form Excel to Access

[eligro]

Hello,
I am sorry for my bad english, I hope you'all will understand me. thank you.

I am making program for a business with 50 workers.
These workers write their schedule hours on Excel. for every worker have a new Excel file every month. the Excel name is "workerame-11-2011" (e.x.) and there inside 3 sheets. The first sheet is the relevent to me. (I attached the Excel file)
the Director of finance require from me that the program will include an option tם load a ll the Excel files (50 in 1 file) at once.


I try to began from here http://www.accessmvp.com/KDSnell/EXC...ImpBrsFldFiles
but after some attempts (by enter the code to the VBA of a button and press on it) I don't get nothing. no warning message even about worng. jus clicked.
I try other options I found on the server and I success to import files but not close to as the Director of finance want.
can you help me please, or at least to show me more good tutorials for this.

[Robeen]

Hi Eligro,

I'll try & summarize what you said to see if I understand you correctly - ok?

You need to import Sheet1 of 50 Excel Spreadsheets into one Access Table - is that correct?

What do you mean "(50 in 1 file)"?