Option Group vs Custom field
First create a custom field of type select or multi-select with empty options. From civicrm_custom_field table grab the option_group_id for the field.
You can use Option value importer extension to import all the options using csv or have a insert query to insert records in civicrm_option_value table using option_group_id from civicrm_custom_field.option_group_id