Using Excel via ODBC

[LondonManc]

If you've got access to SSIS, you should be able to do this straight out of the box.

[MyUserName]

My condolences

Is this to push something to Excel or for Excel to pull from your product?

Both. Provide an engine with which the user can drive Excel via ODBC

[MyUserName]

Connecting to an ODBC source Excel should get the data type from the ODBC driver of the DB its connecting to (tabledefs/catalogs) not via its text import crystal ball malarky.


https://docs.microsoft.com/en-us/sql...ql-server-2017

https://docs.microsoft.com/en-us/sql...ql-server-2017


You never ever want Excel to try and guess what data type it is, its wrong more often than a poster in the B***** forum!

The problem is that if there is no data in the column Excel does not know the datatype it was created as so it assumes it is a varchar. This buggers things up for us as we need to know the column type that it was created as :-(

[LondonManc]

Both. Provide an engine with which the user can drive Excel via ODBC

Have a read through this; it may help:
Microsoft SQL Server Integration Services: Mixed data types in Excel column