CSV is the way to go. Excel should recognize. BCP or File Destination Data Pumps work well.

Obviously a few ways to do this. Replication is one...Especially if you start needing to worry about Delete's. If it is SQL Server to SQL Server then SQL...