milkman2500
Registered User.
- Local time
- Today, 14:29
- Joined
- Oct 21, 2012
- Messages
- 45
Hi,
I've created my tables and a normalized efficient way and queries are currently pulling from these tables.
I'd like to be to pull in historical data from prior years, but I don't have enough data to create the relationships in the tables to make it efficient. The current format of the historical data is in an excel file with lots of text. So rather than having the manager's ID, I have the manager's name.
I could upload the spreadsheet as a table, however I was wondering if there are more efficient ways someone could recommend? Does it matter whether I upload as an actual table or a link to the spreadsheet for performance?
Thanks.
I've created my tables and a normalized efficient way and queries are currently pulling from these tables.
I'd like to be to pull in historical data from prior years, but I don't have enough data to create the relationships in the tables to make it efficient. The current format of the historical data is in an excel file with lots of text. So rather than having the manager's ID, I have the manager's name.
I could upload the spreadsheet as a table, however I was wondering if there are more efficient ways someone could recommend? Does it matter whether I upload as an actual table or a link to the spreadsheet for performance?
Thanks.
