I have a comma delimited text file with double quotation marks surrounding text. Within each line is a field for dates but they are designated as text(,"01/01/1998",). Ultimately I need to import these into Access but prior to this I modify the files using a VB program which reads, modifies, and outputs the data. During this modification process, I have been using CDate() to convert the text date (,"01/01/1998",)into a date data type (,#1998-01-01#,) but when importing into Access, I get an error. Is there another function or statement I should use to convert the text date into a date data type that Access will recognize?
Thanks in advance, showme
P.S. more points may be awarded pending difficulty