¤ I'm trying to get an Access Crosstab query to fill a VB.NET datagrid. I'm getting an error that states "not a valid file name".. the query runs fine when I run the same SQL in Access. Can a dataAdapter be filled with data from a crosstab query?
¤
You may want to post the contents of your query. If I had to take a guess, you're probably using an
Access or ODBC reserved word as a column name. The easy fix is to enclose the column name within
brackets.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)