I have an excel table that has 16 coloums and 100 rows. in each cell is a number. I have used the =INDEX(MATCH..... formula to allow me to input a number corresponding to the first number in any of the columns (pressure) and using the first number of one of the rowns it corresponds to an intersecting cell and displays that number.
Can this sort of table and fromula be inported into access 2003? i currenty have a macro that takes me tothe excel spreadsheet, but i would like to embed the the worksheet into a table then use a form to allow the end uer to interigate the table to produce the requred numbers.
I have tried linking the spreadsheet to a table, but i cannot input the data into a from and hve it interigagte the table t prvide me with the numbers i need.
Cheers
Can this sort of table and fromula be inported into access 2003? i currenty have a macro that takes me tothe excel spreadsheet, but i would like to embed the the worksheet into a table then use a form to allow the end uer to interigate the table to produce the requred numbers.
I have tried linking the spreadsheet to a table, but i cannot input the data into a from and hve it interigagte the table t prvide me with the numbers i need.
Cheers