Separating mutliple data in one MS Access table column
I imported an excel spreadsheet into Access and want to know how to separate data from one column into two columns. The column is [Last Inventory Software Scan] and the data it stores is date in format(mm/dd/yyyy) and time in format(hh:mm am/pm). The time isn't required and don't know how to separate it or should i separate it within excel before importing? If best to separate in excel, what are those steps.
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.