Link with Excel

[Eva]

Hi
I know how to link Excel files with Access database, but I am wondering if
1) we can link Excel file starting row 6 (row 6 bacame heading)
2) I have the file called "AAA Jan-09", next month the file replaces the
previous fale and is called "AAA-Fab-09". I would like to link Access with
Excel for files called "AAA*".

I don't know if it is possible

 

[Douglas J. Steele]

Unfortunately, you can only link to a specific file, not to a wildcard.
You'll have to write VBA code to determine the appropriate file and link
that way.

 

[Eva]

Thank you.
--
Greatly appreciated
Eva

Unfortunately, you can only link to a specific file, not to a wildcard.
You'll have to write VBA code to determine the appropriate file and link
that way.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)





.