Automating a table update?

C

curtis.schmitt

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.
 
C

curtis.schmitt

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
 
A

Alex Dybenko

Hi,
so you can loop through file in server folder using dir (see example in
help), get file name into string var, then check if table exists using
tabledefs, if not - then import it.

dim tdf as tabledef
on error resume next
set tdf=currentdb.tabledefs(strFilename)
if err.number =0
'table exists
else
'table does not exists, import it
end if

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