My client will receive a .dbf (fox2) file every week and needs to
append it to an existing sql server table. The format will always be
the same, but the .dbf file name will change from week to week.

Is there an efficient way to write a program to do this? They are NOT
computer savvy and would not want to run the upsize wizard themselves
ech week (nor do I want to give them that kind of capability!)

Thanks in advance.

Monica

Hi Monica,

You can create an updatable remote view for example,
and do something like
Append From ThisWeek.DBF
If Not TableUpdate()
&& error handling stuff here ...


hth
-Stefan

"Monica J. Braverman" <monica (AT) datashark (DOT) net> schrieb im Newsbeitrag
news:d70cd025.0310081126.22821146 (AT) posting (DOT) google.com...