Notes for importing and exporting SQL Server and Excel Data

Example: Select * From OpenDataSource ('Microsoft. jet. oledb.4.0 ', 'Data source = "D:/yux/vbprj/data/test.xls"; user id = admin; Password =; extended properties = Excel 5.0 ')... sheet1 $
The following... is required. sheet1 $ is the worksheet name, and the $ symbol is also required.

The first row of an Excel table is the field name by default. If it is not the field name, the record of the first row is forcibly treated as the field name. It is useless to insert null rows and will be ignored automatically.