Hello,
i need to populate one of my tables with values from an excel spreadsheet.
of the fields is a self incrementing key field, which is not in my excel
and another is "date last modified" which has a default of "getdate()" it's also not in my spreadsheet.
when i try to import data with those two fields missing, i get errors, am i supposed to hard code those fields into my excel? is there a work around?
Thanks!
i need to populate one of my tables with values from an excel spreadsheet.
of the fields is a self incrementing key field, which is not in my excel
and another is "date last modified" which has a default of "getdate()" it's also not in my spreadsheet.
when i try to import data with those two fields missing, i get errors, am i supposed to hard code those fields into my excel? is there a work around?
Thanks!