G
Guest
I have been given data that sits in two different kinds of files. I have
four years of Excel spreadsheets (formatted alike); one for each day. I also
have the same data in a number of databases (one for each month) in tables
(one for each date).
My challenge to you is to suggest the best way to import that data (and
whether to take it from the databases or spreadsheets) into one table on one
spreadsheet.
four years of Excel spreadsheets (formatted alike); one for each day. I also
have the same data in a number of databases (one for each month) in tables
(one for each date).
My challenge to you is to suggest the best way to import that data (and
whether to take it from the databases or spreadsheets) into one table on one
spreadsheet.