April 14, 2020 at 7:58 am
Hi,
I last used Access/SQlserver about five years ago and have forgotten more than I learnt <grin>.
I have created a SQLserver table for the import of data from audit logs. I only have screen-access to the tabulated logs and cut&paste from the screen to Excel which provides columns of text. I have created the SQL table manually using nvarchar(255) for each field - adding a primary_key field on the front. There are two date/time text fields - an example being "Apr 13, 2020, 11:02:11 AM". I would like to be able to sort by date/time and so have added two datetime2 fields. I then use SMSS to import the logs a day or two at a time ( a few thousand entries a day). I use Access as a front end - the tables being linked.
My question is - how do I fill the datetime2 fields? Using an Access query gives a type missmatch (datevalue()).
many thanks - Chris
April 14, 2020 at 8:11 am
Hi - Access 16, SMSS 18.5, SQLserver 2019 running on Windows 10.
April 14, 2020 at 8:38 am
NVARCHAR()??? You sure you need that?
Access Date/Time data type maps to SQL Server Date/Time data type, not DateTime2.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply