TableAdapter Update WAN vs LAN performance

[BrenB]

I work remotely from my office and connect to the Windows Domain over
the internet using Microsoft VPN server and Network Connection.

I've developed a WinForm application in .NET 2.0 that imports an Excel
document into a SQL Server database.

I add about 1,000 records to a TableAdapter using
BindingSource.AddNew.

If I run the app from a machine on the LAN, the call to
TableAdapter.Update returns almost immediately.

If I run the app over the WAN, the update times out after adding about
700 records.

I know I should be able to import records over the WAN, because I have
done so successfully in Enterprise Manager or Management Studio using
the Import Data Wizard to import an Excel Doc.

Is there a better approach than using TableAdapter if I want this to
work over the Internet?

Thanks, Bren