hi,
can you help me out? I have max12 xlsx file that cover the 12 month. I would like to import it to 1 my MS access in 1 big data table. my 12 file has the same order, so every column is the same every month. however the line number is different, like example in feb I have 80k lines, march 100k.
I managed the import and Append the tables to 1.
however I have a struggle, because the current month data is need to be changing . so I would like to link 1 table as a linked table.
I did the following
link the current month table, and tried to add the old data tables (as append for the linked one), however i can not do that because I have an error: operation must use an updateable query?
how can I fix it? or any idea how can I manage to append 12xls to 1 ms access data table. 1 table [the current month] need to be linked, because the values can change during the [current]month
thank you