Attaching excel tables

  • Thread starter Thread starter Vincent
  • Start date Start date
V

Vincent

Hello everyone,

In my application, I have some external excel worksheets that are
attached (linked) to my database and they work very well.

I have set up the links as "path\filename.xls" (where path is the
directorory containing both the .mdb application and the excel files)
and everythings works fine except if I try to move my application to
another directory.

In this case, the path does not link directly to the excel files that
are in the same directory as the .mdb but to the former one.

I have tried to use the path ".\filename.mdb" but it is not accepted
by Access.

Does anyone have a solution to my problem?

Access 2000 on Windows 2000
 
You can use Application.path to get the current path to the mdb within code,
and reset the path to your excel file based on that.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top