Results 1 to 2 of 2
  1. #1

    Excel, ODBC, Access

    I have a pivot table in Excel 2K pulling data from an Access 2k query. The query runs fine in Access. But before completing the pivot table wizard, this error occurs: [ODBC][Data type mismatch]. SOunds like a comptibility issue between Excel and Access data types and functions. Any ideas? I'm using DateDiff, DatePart, and Date() in the Access query.

  2. #2

    Re: Excel, ODBC, Access

    I solved my own problem. This needed a file dns connection. Now the pivot runs fine. [img]/w3timages/icons/laugh.gif[/img]

Posting Permissions

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