sql - Crosstab query does not work in Excel, but works in Access -


I have a problem that drives me crazy. I have SQL query:

  Select the format [[Meetings]] [Date of meeting], 'MMM as the Transformment slurry (Meetings. [ID]) (Meetings) [meeting]], meeting (meeting)], draft ([meetings] [meeting date], 'mum') by month ([meeting] [date of meeting] by order, year (meeting) Meetings [date of meeting] PIVOT years (meetings. [Date of meeting]);  

It works well in access, but when I execute it from Excel, I do not get any records. Opening the recordets part is 100% correct, because it works fine with other queries Does anyone know why a record receives?

If you want to import crosstab queries in Excel, access requires you to jump through some hoops is. Crosstab can not be prepared by Excel, so you should

  • create your own crosseset query in Access
  • Create a create table query that is just Select from your cross tabs in StaticCross tab *
  • Go back to Excel and import your data as

Like a pain, but this is the best way to access cross tab data in Excel from Access. Do not pivot in optional entry and instead you want to use a pivot table in Excel to create crosstab. Sometimes it depends on the axis, it is not possible.


Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -