| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel into DataTable using OleDbDataAdapter
Matthew_H wrote:
Query fails to fetch Excel data formatted as currency. How can I get currency data from Excel First, ensure your data actually is of type Currency. Formatting is a factor but no guarantee e.g. Text in a column with a currency format is still Text. Ensure you do not have a mixed types situation - see: http://www.dicks-blog.com/archives/2...ed-data-types/ Jamie. -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart's DataTable | Charts and Charting in Excel | |||
| Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
| Can anyone align the numbers within the datatable of a chart? | Charts and Charting in Excel | |||
| DataTable number format | Excel Programming | |||
| Problems using VB.Net OleDbDataAdapter and Excel | Excel Programming | |||
Hybrid Mode
