Hi

[Vugar]

Hi everyone,

Could you please help with one issue:

I have a database Time Sheet DB.

weekly staff send their Time Sheets (Access file) data and import them unto my Time Sheet DB.

how to do it so that the data is automatically loaded?

thank you very much

 

[The_Doc_Man]

Look into the DoCmd.TransferSpreadSheet topic.

If there are lines in the spreadsheet that you DON'T want to see, then import to a temporary table, then filter it before you append the contents of the temp table to your main table.

This is intended as a gentle reminder. Put the salutation (like "Hi") in your post body. Put a more meaningful topic for the subject of the post.