Moving Multiple MDB files into SQL Server

Hello,
I have multiiple MDB files to move into SQL Server 2000. What is the best
way to import these files? I want to keep checking
a certain network folder to see if a new MDB exists. If so, I'll move it
into the SQL Server,
then move the MDB file to a subfolder, then I'll check to see if any other
MDB files exist on the network folder.
Thanks
DonHi,
You can import the MS Access (MDB) tables to SQL server using DTS.
Thanks
Hari
MCDBA
"Don" <dons100@.ameritech.net> wrote in message
news:91eCc.27585$eH1.12952254@.newssvr28.news.prodigy.com...
> Hello,
> I have multiiple MDB files to move into SQL Server 2000. What is the best
> way to import these files? I want to keep checking
> a certain network folder to see if a new MDB exists. If so, I'll move it
> into the SQL Server,
> then move the MDB file to a subfolder, then I'll check to see if any other
> MDB files exist on the network folder.
> Thanks
> Don
>