MS SQL Server ODBC - Runetime Error 13

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Runetime Error 13 - Type Mismatch

Dan

2006-10-24, 6:40 pm

In my excel spreadsheet (office 2k3) I am using ODBC to pull information
from an sql database. When I just use the query it works fine (Data -
Import External Data ...). However, I copied the SQL statement from the
Query Wizard into my macro and now I get a Runtime Error 13 - Type Mismatch.

I've done this in other queries and have had success even though I don't
really know what syntax VB is expecting for the SQL statement.

Can anyone help with this?

Dan

Sponsored Links