inserting query into table

[kiranair]

I have same problem exactly the same like Import excel data to query thread !!!!.
I have around 30 columns in which around 2 columns have complicated calculations that can be done using query ,which are related to other columns .Using this table I have already created a complex quires to get the desired output, thought the table with 30 columns is completely entered manually but it isn't !!!!!!


eg: Table(column 1.........column30)
column 3 has has got numeric values which are generated looking upon some tableX and column2


My problem is how to make column 3 fit in to the same table also my main work is excel sheet is imported to access to do certain calculation and return it back into excel with calculated values and graphs
Please help.

[John_G]

...excel sheet is imported to access to do certain calculation and return it back into excel with calculated values and graphs.

If you are linking to the Excel worksheet, using it like a table in a query, and updating some columns, you can't. A linked Excel worksheet cannot be updated in a query.

The Excel worksheet can be updated using VBA, but it is not trivial programming.