| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC imports numbers as text
When I use ODBC to import data into Excel, all numbers come through with a
leading apostrophe so that Excel sees them as text. e..g INSERT INTO [Sheet1$] VALUES (10) will come into Excel as '10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| truncation with imports via html | Excel Worksheet Functions | |||
| Data Imports incorrectly | Excel Discussion (Misc queries) | |||
| Can delimited text file imports be extracted to a single column i. | Excel Discussion (Misc queries) | |||
| Imports | Excel Programming | |||
| Updating Excel imports | Excel Programming | |||
Threaded Mode
