P
Pete
Hi,
I am building a sales database. My main sales data is contained in SAP
which I then dowload to Excel. Ideally, I would like to have one spreadsheet
but the 2006 data is 46,000 rows and the 2007 data is (so far) 28,000 rows
which means it exceeds the number of rows allowed in a spreadsheet.
I have come up with two alternatives :
1) I have to IMPORT both 2006 and 2007 spreadsheets into one table every
time the sales data is updated (this is virtually everyday so would become
quite time consuming).
2) I import 2006 and LINK 2007 then use UNION ALL in SQL to make one table.
I have tried this but it is quite complicated as there are several other
tables involved in my database.
If anyone can think of a better alternative I would love to hear from them.
Many Thanks
Pete
I am building a sales database. My main sales data is contained in SAP
which I then dowload to Excel. Ideally, I would like to have one spreadsheet
but the 2006 data is 46,000 rows and the 2007 data is (so far) 28,000 rows
which means it exceeds the number of rows allowed in a spreadsheet.
I have come up with two alternatives :
1) I have to IMPORT both 2006 and 2007 spreadsheets into one table every
time the sales data is updated (this is virtually everyday so would become
quite time consuming).
2) I import 2006 and LINK 2007 then use UNION ALL in SQL to make one table.
I have tried this but it is quite complicated as there are several other
tables involved in my database.
If anyone can think of a better alternative I would love to hear from them.
Many Thanks
Pete