cannot place this validation expression on this field error

[Dominic1980]

Hi

I have the error "cannot place this validation expression on this field" whenever i try to DoCmd.transferdatabase. I'm thinking it's because i altered the field type of my table before doing the transfer that's why it's giving this error. I altered the field type from Text to Datetime using a query. Can somebody help me out with this? thanks in advance

Reg
Dom

 

[llkhoutx]

Your pushing you Access data into a formatted Excel sheet. Their respectiuve columns must be of the same datatype.

I always push to a new spreadsheet or delete all the cells in the sheet to receive that push.

 

[Dominic1980]

I'm backing up my database in acces. not pushing to a formatted excel spreadsheet

 

[llkhoutx]

Sorry for the bad response.

I altered the field type from Text to Datetime using a query.

I suspect your altered data may not be correctly formatted. What does the query result for that field look like. It probably doesn't match the target field.