Excel link problem

  • Thread starter Thread starter Ray C
  • Start date Start date
R

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.
 
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
 
Back
Top