Hello,
I am a new user of Access. I am building a database. I have 3500 "date" records in the following format: "04/21/05 01:30 CDT", the field DATA TYPE in table design is set as "TEXT".
I wish to change the DATA TYPE from "TEXT" to "DATE/TIME". However, everytime I attempt this, an error appears: "Access Encountered errors while converting the data -- the content of 3500 records were deleted. Do you want to proceed anyway?" If I click yes... all the records are deleted.
Please help. Thanks.
I am a new user of Access. I am building a database. I have 3500 "date" records in the following format: "04/21/05 01:30 CDT", the field DATA TYPE in table design is set as "TEXT".
I wish to change the DATA TYPE from "TEXT" to "DATE/TIME". However, everytime I attempt this, an error appears: "Access Encountered errors while converting the data -- the content of 3500 records were deleted. Do you want to proceed anyway?" If I click yes... all the records are deleted.
Please help. Thanks.