"Datatype mismatch" error when importing from Sequel table

[KerryL]

Table A is a linked Sequel table, Table B is an Access table. I'm getting a "Datatype mismatch" when my program pulls selected data from Table A and then stores it in Table B.

I've already matched all the field types (text-to-text, numeric-to-numeric, etc) and I'm not sure what else to check.

A co-worker mentioned to me that he's had trouble in the past when taking data from a Sequel integer field into an Access numeric field.

Anyone familiar enough with what I'm trying to do to maybe understand what may be happening or what I need to look for?

Thanks in advance,
KerryL

 

[Crowley16]

well, is your data only text or numeric?
is there date datatypes in there somewhere, or other more complicated datatypes?

if everything fails, then maybe you can cast everything to strings, and then reformatt them before storing in your table B

 

[KerryL]

There are different data types. A few text fields, a couple of numeric fields, and a couple data fields.

I wouldn't know how to cast them all into strings and separate it back into the fields in Table B.