I've currently been assigned with the task of maiking our DB be able to export a table to a spreadsheet, whereupon people would then be able to update records at home. They would ideally then return to work, and be able to import the spreadsheet to be appended to the table that it originated from. The thing is, it doesnt seem that you can import a spreadsheet to be appended to a linked table. I havent looked into the programatic solutions as Im just trying to get the understanding of how one would go about this manually.
If I go to Get External Date -> Import... and follow the wizard and try to append the spreadsheet to an existing table, there are none available in the dropdown box. Does this mean that to append an imported file to a linked table that I would actually have to import into the file that holds the 'real' tables or is it possible that I'm just overlooking some mundane detail (I always do that). Any suggestions or advice anyone would have would be greatly appreciated.
-Jedi420
If I go to Get External Date -> Import... and follow the wizard and try to append the spreadsheet to an existing table, there are none available in the dropdown box. Does this mean that to append an imported file to a linked table that I would actually have to import into the file that holds the 'real' tables or is it possible that I'm just overlooking some mundane detail (I always do that). Any suggestions or advice anyone would have would be greatly appreciated.
-Jedi420