Creating activity and populate activity journals from ext. data

We are looking to create activities and corresponding journal entries from an external database application.

The external database is SQL, and there are 30,000 data records.

What is the best approach for mass load of external data into a CRM activity.

Thanks