This is my very 1st post - probably of quite a few!
Before I start my first database I would like to know the answer to this question if anyone can help and I am sure its pretty basic.
I have various excel spreadsheets going back to 2008 when I started itemising some expenditure data I start a new sheet every year. However during the period 2008 - 2017 I may have added in new information into different columns than I previously collected at the beginning back in 2008.
My question is this:-
Can I upload all of these files into individual tables and then be able to create some sort of relationship between them that will allow me to extract the data I may be looking for?
2008 - may have columns A-H
2007 - May have columns A-M
I know I cannot append the table as each spreadsheet may have extra columns etc that don't look the same as the one and when I have tried it throws all sorts of errors.
I wonder should I get all the spreadsheets exactly correct before uploading?
Thanks
Before I start my first database I would like to know the answer to this question if anyone can help and I am sure its pretty basic.
I have various excel spreadsheets going back to 2008 when I started itemising some expenditure data I start a new sheet every year. However during the period 2008 - 2017 I may have added in new information into different columns than I previously collected at the beginning back in 2008.
My question is this:-
Can I upload all of these files into individual tables and then be able to create some sort of relationship between them that will allow me to extract the data I may be looking for?
2008 - may have columns A-H
2007 - May have columns A-M
I know I cannot append the table as each spreadsheet may have extra columns etc that don't look the same as the one and when I have tried it throws all sorts of errors.
I wonder should I get all the spreadsheets exactly correct before uploading?
Thanks