Mariano Gomez has a nice look at GP’s Table Import functionality. Every so often, Table Import is the best option so it pays to understand how it works.
Table Import
SQL & DataDevelopment & Integration
Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.