I am using an excel sheet containing around 200 records and linking it to my MS-Access database through the Link Table option available in MS-Access.
But I need to change it everytime when I go from one system to another as the path of the Excel file changes. That is, I need to delete the link table and recreate it, everytime I change my system.
Is there a way to create a link table from my VB code so that the link table can be created in MS-Access database from the application path dynamically? The Excel file, I am trying to link is in the same folder of my VB Project.
Please help me.