Relative Content

Tag Archive for sql-serverexcelms-access

DateTime to Date in Excel from MSAccess and SQLServer datasources

I inherited a very old project. Currently, there is an MS Access 2019 database. This DB has DSN to a MSSQL Server db. There are cross tab queries in MS Access that pulls data from MSSQL and exports that data into excel. The issue is, that dates are coming back as datetime and not date only. They are date only in MSSQL, but somewhere along the way, they are getting converted to datetime.