DTS, Excel and mixed format columns(geekzilla.co.uk)
submitted by
phayman(3550) 4 years, 11 months ago
I recently had a problem DTS importing an Excel spreadsheet which contained columns with mixed text and data values. After a bit of hunting around, I found an extended property IMEX=1. The IMEX=1 property forces everything to text when reading from a source. read more...
|category: Database
|Views: 2
tags:
another
Everyones tags:
No tags
Your Tags: