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

* "=?Utf-8?B?R3JlZyBCdXNieQ==?=" <(E-Mail Removed)> scripsit:
> 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 will more likely get an answer here:

<news:microsoft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>

On Wed, 3 Mar 2004 15:56:08 -0800, "Greg Busby" <(E-Mail Removed)> wrote:

¤ 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 Removed)
Microsoft MVP (Visual Basic)