Trying to avoid using SSIS and just bcp in sheets of a workbook. Is it possible? Thank you!
asked May 18, 2017 at 08:51 PM in Default
Not BCP or BULK INSERT for Spreadsheets. OPENROWSET using the "ACE" drivers (provided by MS). They can be "hard mapped" like most folks end up doing in SSIS or, with a bit of experimentation, can be auto-magically mapped to overcome the perennial problem of people adding columns, etc, etc. I'm not at home right now and so don't have access to the links I sometimes refer people to. I'll try to remember to come back to this sometime tonight.
answered May 18, 2017 at 09:45 PM