| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel schema using Jet OLEDB Provider?
Is there a way to query the Jet OLEDB Provider for Excel
to find out the COlumn Names and DataTypes of an Excel worksheet? I want to import an Excel file into SQL Server and need to create the table on the fly for that file and set the column datatypes for that table. What would be the best way to accomplish this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing OLEDB drivers in Excel 2000 (9.0.28.12) | Excel Discussion (Misc queries) | |||
| OleDB Provider for Excel 2007 Binary (.xlsb) | Excel Discussion (Misc queries) | |||
| OLE DB provider cannot connect to Excel 2007 with 400 columns | Excel Discussion (Misc queries) | |||
| Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
| Connectiong to an Excel Workbook with MSDASQL provider | Excel Programming | |||
Threaded Mode
