Re: Automating a table update?

Alex,

I have a set of tables in the database that all have a standard name
for the first half of the table name and then the second half is a
date. I then have a server location that holds a set of excel
spreadsheets with the exact same names. What i would like to do is
have the database compare the filenames to the table names. If there
is a new file name, have it imported into the database as a table with
the same file name. Please let me know if you have any other
questions.

Thanks
Curtis

Alex Dybenko wrote:
Hi,
you can use autoexec macro, then it will automatically run when you open mdb
file. for read files in a folder you can use Dir() function. not sure what
do you mean with "compare files with tables"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

<curtis.schmitt@xxxxxxxxx> wrote in message
news:1168659259.796990.254240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to develop a macro that runs when the database starts up.
The goal of this macro is to go out and search a specified server
location and compare the files in that location to the tables in the
database. If it finds that there is a new file relative to the tables
in the database, I would like for the database to automatically pull
this into a table in the database. If anyone has ever done this before
or has any guidance how to do this, I would greatly appreciate the
help. Thanks Curtis.


.