I haven't tried Michael's tool - but it sounds interesting.
I would use SQL servers DTS for this stuff. There is even a wizard you can
use to get started, then set it up on a schedule. DTS is very powerful and
is often overlooked. There is a great book on it if you are interested --
"SQL Server 2000 DTS".
:)
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Alok" <al*********@yahoo.com> wrote in message
news:dc**************************@posting.google.c om...
Hi,
I recently upsized my access database to an ADP project with SQL
backend. However when I did it the import/export specs were not ported
to the new database. Also in the ADP files I am unable to create new
import/export specs. The option is greyed out. I need to use the specs
with the TransferText function.
How can I get around this issue?
Alok