Recent content by celia2

Thanks for your reply. However, I must have the data to transfer from excel to Access because the every time new data are entered in the excel spreadsheet. Some of the related cell/ data are then stored in aacess database for further actions. So, I think coding are needed to be in either Excel...

Hi, Can someone point me some example/sample for the coding to export data from Excel to Access or vice versa? I am doing a timesheet in Excel and would like to collect the timesheet data into Access database where I can do the other calculations. I create the table alredy but not sure how to...

What if only certain data from excel form are needed to be store in the access database? I created the excel forms for users to enter data then want to store the necsassary data into database for calculation purposes. Please help! Thanks, celia

Hi all, Can I transfer data from Excel to be stored in Access database? Is there any code or reference regarding this? Thanks, celia

No, I dont think I need that because it up to them when they want to fill the form. They need to done it by the end of the month, that's it. Therefore, I need to create login for them and command buttons to enable them to save or delete data. DO you think I have made things too complicated...

Thanks for the idea. Not much like what I want because my timesheet is used to record the works done by each person on each working days. Anyway, will look and understand. Thankyou very much.

Smercer, Yes, you could not find the 4 sections in my Excel timesheet because I only propose to add in when I create the Access form. Actually, the Excel timesheet is given to the staff and they fill it. After they submit, then I combined it in pivot table according to sections. So, all the...

Hi, I guess you are answering my question regarding Excel. I have attached the pivot table I created which was actually link to the individual timesheet for your reference. Answering to your question, I want it without the link so it does not update when I change it in excel. I hope you can...

Hi, I am doing a monthly timesheet in MS Excel for the use of 25 staff where each of them will fill the individual form and send to the server at the end of each month. There are 4 sections: Admin (5), Accounts (2), Sales(6) and Others. Now, I want to switch to MS Access. I try to using the...