Problems with Inserting into Access 2000

Results 1 to 2 of 2

Thread: Problems with Inserting into Access 2000

  1. #1
    Tony Guest

    Default Problems with Inserting into Access 2000

    Here&#039s the setup:<BR><BR>I&#039ve got two seperate tables in Access 2000, one with phone records, the other with customer information, which I&#039m trying to combine in one table. I&#039m using a SQL join to take both tables, and make one table out of them in ASP. I then use an insert add the new data into a table I&#039ve already designed. The tables contain short dates, short times, long numbers, memos and text fields. When I go to do the SQL Insert, I get this message:<BR><BR>"Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.<BR>/AccTicket/test2.asp, line 20"<BR><BR>Why am I getting a data type mismatch when I made sure that the fields in the new table are identical to the old fields?

  2. #2
    Tom Anderson Guest

    Default What does your update look like?<NT>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts