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?

Hi,

few thoughts on this issue;

1) Trim the day in the long date.
2) update the date field to date using DateValue function
for ex:
select DateValue("26 August 2003") will return "8/26/2003".

all these can be done using sql statements.

Good luck.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.