Hi
trying to import as spreadsheet with 85000 records
On field in the spredsheer is designated as text.
If I import it into access table and specify the field format as short text it imports with no errors but
aany date with 1900 is converted to a number
ie
14/05/1902 in excell becomes in access 865
07/jun/1902 in excel becomes 889
yet 30/04/1896 in excel becomes 30/04/1896 in access
Am I missing something
thanks
Ian