I have an sql table that has a field that is defined: [Finish] [time](0) NULL.
I am linking the table to an access database and then typing the data directly into the table. If I use military time the data gets saved without a problem. If I type in non military time like 1:34 PM I get an error: invalid character value for cast specification.
Is this possible to do? Do I need to change the data type of the column?
Originally I had the field defined as a datetime field the person who hire me for the project does not want to see the date. They want to be able to cut and paste the information into the table. I changed the field to characters but they keep pasting invalid information so that does not work.
I am using access from office 2013 and sql 2012
Any suggestions would be appreciated.
Thanks in advance,