The data is imported into Excel as a table.To unlink the imported data from the external TXT file, in the Ribbon, select Table Design > External Table Data > Unlink.This shows that the data is linked to the TXT file and if any data in the TXT file was to change (external to Excel), the data displayed in Excel would change too. There are now two new tabs on the Ribbon – Table Design and Query – as well as a Queries & Connections pane appearing on the right-hand side of the screen. ![]() The data now appears in a new sheet in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |