Append Queries different datatypes

[whojstall11]

Does anybody know a way to populate data in access without using the append query. Append query is not working because the data types are not all the same and when i try to convert them to be the same they delete.

[Robeen]

Can you explain

the data types are not all the same and when i try to convert them to be the same they delete.

If I understand correctly - you are trying to put data into a table - right?
If so - the data type of the data you are trying to put into a field HAS to match the data type assigned to the field in your table that you are trying to put the data into.

I have done data type conversion in queries in order to coerce the data to the type that is expected in the table - and it works. So you should be able to do it . . .

Can you give us a few more details and maybe show us a screenshot of your table design and your Append SQL?