• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Using Excel via ODBC

If you've got access to SSIS, you should be able to do this straight out of the box.
 
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/sq.../using-catalog-functions?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolumns-function?view=sql-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 :-(
 

Advertisers

Back
Top