ms access crosstab query in aspx page?

[zerkat]

Is it possible to somehow call an Access Crosstab query from within an aspx page?

 

[jbenson001]

Yes

 

[zerkat]

Great, we have an access database used to manage our projects and it has several crosstab queries in it for reports. I am setting up the DALs and BELs now. What would the syntax be to use a crosstab query in the DAL?

Right now all I have is:

Imports System.Data.OleDb

Public Function GetData()

Dim con As OleDbConnection
Dim cmd As OleDbcommand = New OleDbCommand
Dim strConnectionString As String
Dim startDate as String -- for input param
Dim endDate As String -- for input param

strConnectionString = ConfigurationManager.AppSettings("ConnectionString")

con = NewOleDbConnection(strConnectionString)
cmd.Connection = con
cmd = -- not sure what to use here to run crosstab

End Function

Thanks

 

[zerkat]

ok - I am feeling dense today. All I need to do is copy the query from access and put in my function. For some reason I was thinking I could reference it in some way like access.queries.QueryName. Of course Microsoft has not integrated their products that well. I'll just have to do some crazy joining to get it to work - just what I want to start on a Friday afternoon....lovely.