I need to extract some data from an Access 2000 .mdb with user ID and Password.

The .mdb is on a PC with a static IP address.

I can log onto the PC with Microsoft's Remote Desktop Connection.

The database is REALLY, REALLY BIG relative to their DSL speed. Consequently, it is NOT practical to FTP the entire .mdb from the PC to Sql Server. I need to extract the desired records.

The extraction (and subsequent load) process needs to occur daily.

Can I do this?

How do I specify the IP address of the source machine?

How do I supply the PC login and PWD?

I assume, that if I have a PC connection, that I can supply the .mdb UID and PWD to simply execute the Sql calls and retrieve the data. Is that correct?

I appreciate any insight.

Thanks,
Bobby