-Text field in Excel returns null when led by a zero 
Author Message
 -Text field in Excel returns null when led by a zero

 - I am trying to retrieve data from an Excel spreadsheet where one column
lists social security numbers as text values.  All the numbers that begin
with a zero are returning a null value to the DAO data control recordset.  I
have tried both ADO and DAO and get null values from both for text fields
led by zero.  Any help would be appreciated.

Thanks,
Tony



Sun, 18 May 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Text field in Excel returns null when led by a zero

2. Text field in Excel returns null when led by a zero

3. Excel VBA - Pad SSN's w/Leading Zeros

4. Excel Xp VBA - Pad SSN's w/Leading Zero's

5. Fixing Leading zeros in Excel while exporting from asp

6. excel leading zero problem

7. Leading zeros gone after merging wordfile with access data fields

8. How to save leading zeros in numeric fields?

9. VsFlexGrid 7 suppressing leading zeroes when text value entered

10. COM-Variable returns always Zero instead NULL

11. Null to Zero field values

12. DAO 2.5 won't convert zero length string to null in date field

 

 
Powered by phpBB® Forum Software