Connection Excel to Access -- Lineal data to Structured data

Dear All,

Thanks for your support in advance :)

I am looking to move an Excel Data Base to Access in order to improve efficiency and bring security to the data hold.

The problem that I am stacked is related with the loading.

I have my table volumes which contains:
Code (unique & key)
Years
Months
Version
Volume

In excel I will have this data but in columns...
2014 2014
Version 1 Version 2
Jan Feb March... Jan Feb March...
Code 12 20 15 ... 22 33 25 ...

Is there any option to keep the excel file whit the current structure to load the data?

Thanks in advance for your help!

Best regards,
Dimitri

0 answers