Solved Remove linked excel from Access db

[ImruDa]

Hello everyone!

I am using the below code to link my Access db to excel and name the linked excel as "Tabelle1". After using the data from excel I want to remove this link and make free Access from excel. How should I do it through VBA ? Thank you for help

 DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12Xml, "Tabelle1", "C:\Lotus\Newemp", False '<-- Sheet
    CurrentDb.TableDefs.Refresh

 

[Gasman]

https://answers.microsoft.com/en-us...n-access/1900bfae-706b-e011-8dfc-68b599b31bf5

 

[Isaac]

To delete a table you can use

CurrentDB.TableDefs("name").Delete

This would delete a "linked table"'s link just the same.