bulk insert bioRecord_base from 'c:\syn_dump\brb.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert bioRecord_ext from 'C:\syn_dump\bre.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert institution_code from 'c:\syn_dump\ic.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert collection_code from 'c:\syn_dump\cc.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert taxon from 'c:\syn_dump\t.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert higherTaxon from 'c:\syn_dump\ht.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert vernacularName from 'c:\syn_dump\vn.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert isoCountry from 'c:\syn_dump\c.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert resource from 'c:\syn_dump\r.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');

bulk insert imageRecord from 'c:\syn_dump\ir.txt'
with (keepnulls, keepidentity, tablock, DATAFILETYPE = 'widechar');