How can I use an Excel spreadsheet as a datasource?
The ODBC source points to the file. The “table name” is the sheet name with a $ on the end, but always put square brackets around it; [Sheet1$] Row 1 MUST, I repeat, MUST be the column names Once a column is decided upon (setting in the ODBC) for it’s data type, it’s GOT to be that datatype, other types will be ignored (i.e. putting some text in a column that starts as numeric will return a NULL). Formatting for visual needs means nothing to ODBC, it’s the actual data which determines it’s type – you must FORCE it to be text if you want text On this point, unless you want to release the ODBC before you upload, then use an Access database and Link Table to point to it, but the same ODBC limitations apply How to force a cell to be text; You need a “copy” column beside it and put the following formula into it; =Mid(“‘”&a2,2,Len(a2)) Assuming that A2 is the cell that contains the original data Also, Sometimes you get blank rows at the bottom of the table, these DO count as rows – so be ver
Related Questions
- If I use Excel, another spreadsheet, my Mac, or WebCT to manage grades and only want to use MMS to submit my final grades to the Registrar, how can I transfer my grades into MMS?
- User copies several values (at once) from a local excel spreadsheet and pastes them into the jdatagrid, is this feature supported?
- Whats the advantages of a database versus my paper system or an Excel spreadsheet?
