Results 1 to 2 of 2
Thread: Excel, ODBC, Access
2001-02-16, 04:08 #1mmilesGuest
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.
2001-02-23, 21:38 #2mmilesGuest
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]