Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So once I've loaded an Excel spreadsheet but want to add more data from a different spreadsheet without loosing what "ve already added, How do I do that?
Add a second load statement to add the data from the second excel file. When you reload data from both excel files will be loaded.
FirstTable:
Load * from myfirstexcelfile.xls
(biff, embedded labels, table is sheet1$);
SecondTable:
Load * from mysecondexcelfile.xls
(biff, embedded labels, table is sheet1$);
Thank you!
Thank you!
Thank you!
Thank you!