SQL Server vs MS Access

[pachjo]

Could a guru of networking and databases please help me with this problems please?

 

I need to know which of the following methods is better, ie less network pounding....

 

Situation:

 

A sql server database running on a host 25 miles away.

 

two maybe three queries need to be run to import very large data into a local c: drive database.

 

Option 1:

 

An MS Access database application with the required make table queries

 

Option 2:

 

A VB.NET application importing the data into a mdf file using sql server datasource

 

Is my thoughts that option 2 would be more efficient and less network hungry?

 

Thanks for any advice on offer....

Edit/Delete Message