Excel link problem

[Ray C]

I'm programmatically linking to several Excel files in order to import the
data into Access tables. The importing works fine.

I execute the query "DROP Table MyExcelLink" in order to close the
attachment to the Excel file. YET, when I try to delete the Excel file itself
through Windows Explorer, it says that another user is currently using the
Excel file on my machine.

Is this the proper way to close the link when attaching to an external Excel
file?
I've done this in the past and never had any problems.

 

[Tom van Stiphout]

On Wed, 25 Feb 2009 13:14:16 -0800, Ray C

I would use the Delete method of the DAO.Tabledefs collection.

-Tom.
Microsoft Access MVP