Import excel data to query

[maxiz1]

Hello,
I have a table (Table1) which contain approximately 30 columns. I wanted User2 to input the data into say column 10 and 11, which requires him to perform some calculation in Ms excel.

To avoid giving User2 too much data, I intend to achieve this by creating a query to only include the ID, column 10 and column 11 from Table1, and then export to excel. Once the user has updated column 10 and 11 using excel, I will upload it to the main Table.

I found that I could not upload excel to Query, as it only allow it for Table. However, as mentioned I don't want to give the User2 the full Table1.




Please help.

[pbaldy]

If you link to the Excel file, you can run an update query to update the table from it. The user wouldn't see the table.

[Micron]

Yup, linking the spreadsheet would be one way and I've done that. Can't recall if there were any issues around the Excel file being open at the time Access was trying to work on it.
Wondering why the data isn't presented in a form and the necessary entries made there. Forms are most useful for controlling data access and editing.
Also seems that calculated values will be stored in a table. Not sure about that...

[maxiz1]

Thanks for responding. However I cannot use update query or form for User2 to update column10 and 11. He needs to use excel. This is because it involve different calculation for different set of record. To give a glimpse, I'm building a database on equipment reliability. For each equipment, the way to calculate it differs from another significantly due to the difference in equipment and arrangement. It is too complex to automate the equation by using IF THEN thus it needs User2 to do it in Excel.

[pbaldy]

Excel is fine. My suggestion was to update Access from the Excel file, using an update query.