1.) Data is manually exported from Revit to a "Machine Data Source" which is configured to be the SQL Server database.

2.) The data is imported into Access from...

The data type for the table varies depending on the column. There are several "nvarchar" columns but the ones I am focused on are set to "int". ...

Ideally, the data would be converted each time it is passed through SQL Server. I looked at using update queries in Access, but I would have to write...

Thank you for the quick response. I did come across that, but I'm not sure where to apply it. I've been trying to edit the database...