Can financial accounts be imported?
There are likely more tables involved that just that table so I would not go directly into the database. There is an api for creating financial accounts so you could try using the csvimporter extension to import them. I believe it is available as a downloadable extension from your manage extensions page.

I would suggest just importing one and then looking to make sure it looks correct before doing more. Not that there are at least 3 entities involved - financial types, financial accounts &amp; the one that links them.

Financial accounts have the cost code information and financial types are what the user selects. Each Financial type should have a number of related financial accounts for different purposes (income, expense etc) - so just look to make sure they look the same through the UI before you go for 100 imports