|
|
|
|
|
|
|
|
Dicas
|
|
|
Visual Basic (Strings de Conexões)
|
|
 |
Título da Dica: Excel (OLE DB)
|
 |
|
|
|
Postada em 27/3/2004 por ~Ð@®£@Ñ
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
|
|
|
|
|
