Data Type Mismatch

[Faded]

Hello,

Using Access 2002, I am trying to create an APPEND query. It queries a linked FoxPro table, and appends two columns to a linked SQL Server table. The problem is that the FoxPro table's PK is of datatype TEXT and contains all numeric data except for two rows of text (which are not needed) and the SQL Server column I am trying to append to is NUMBER therefore giving me a type mismatch error when I run the query. I can't change the datatype in either table. Is there anything else I can do to allow this query to execute and just drop the unneeded rows?

Thanks, Faded

 

[gol4]

I'm sure there are probably easier ways but can you make a temp table with the proper type append to that then change the type and append to the other/

 

[cmmrfrds]

Just filter out the rows with the non-numeric column.

Where yourcolumn < &quot;A&quot;