That's the best way. Think of your existing table as a "Staging" table. Staging tables hold raw data imported into the database, usually without any cleansing or formatting applied. The data is then transfered to one or more production tables by a stored proc that verifies it and reports any abnormalities.
If it's not practically useful, then it's practically useless.