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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy