By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 IT Pros & Developers. It's quick & easy.

Access Crosstab query in VB.NET

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "=?Utf-8?B?R3JlZyBCdXNieQ==?=" <Gr********@hotmail.com> 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/>
Nov 20 '05 #2

P: n/a
On Wed, 3 Mar 2004 15:56:08 -0800, "Greg Busby" <Gr********@hotmail.com> 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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.