Hi,
I recently imported about 18,000 records from filemaker into access. I initially exported the data as a csv file, i then opened it with excel and saved it as an xls spread sheet. Once i cleaned all the data i proceeded to import it into access, however i now have the problem that a date field is in text format.
The date is in a long date format eg. Tuesday, 26 August 2003
I tried changing the format to date, but access then deletes all the records. Is is possible to convert these text dates to the date format?