I want to create a page where the user is saying which A he wants to see (A1, A2, A3... etc), which Value he wants to see (Value1 , 2....) and also which rows he wants to see from 1 to 10 (5,6,7 for example...).
My knowledges of Access are totaly limited and don't have much time to learn. Your help is totaly needed Thanks.
What i understood is that i need to make somehow a "transpose" from excel.
I have all the date in Excel and when i'm importing it creates for each spreadsheet a separate table. The thing is that i can not use transpose because on the column "Name" I have 360 rows.... so the amount of date is huge.
can i import like it is in access and than make the transpose with access? however i'm not sure it can support 360 columns (or fields)....
in the tables in acces all the columns have 360 rows of date... so each field has 360 values, that's why i'm saying that it is dificult to transform the rows in columns or so to speak to have 360 fields
columns i have about 20 in each table... the quantity of date is huge