VB.NET Microsoft.ACE.OLEDB.12.0 - Select by col

Asked Oct 17 '17 at 21:12

Active Oct 18 '17 at 09:03

Viewed 350 times

How to make Sql Select by column number and not by name with Microsoft.ACE.OLEDB.12.0 - Excel?

Ex: Select [Col1], [Col4], [Col5] from [dados$]

edited Oct 18 '17 at 09:03

Johnny Willemsen

asked Oct 17 '17 at 21:12

F1, F4, F5 - Header=NO in connstring – Steve Oct 17 '17 at 21:17
@Steve - Could not find installable ISAM. – Renato Sucoski Siqueira Oct 17 '17 at 21:23
1

https://stackoverflow.com/questions/8797978/how-to-resolve-could-not-find-installable-isam-error-for-ole-db-provider-mic – Steve Oct 17 '17 at 21:25
1

Yea working... Extended Properties='Excel 8.0;HDR=NO;IMEX=1'... Ty @Steve – Renato Sucoski Siqueira Oct 18 '17 at 00:15

0 Answers0