Import crosstab query as a table using code

  • Thread starter Thread starter LJP
  • Start date Start date
L

LJP

I have a crosstab query that I would like to import from my current database
into my current database as a table using a module. Can someone please help.

Query name: Query_BLB1

Would like tablename to be: BottomLineBalancing.

Thank you in advance for any assistance.
 
I have a crosstab query that I would like to import from my current database
into my current database as a table using a module. Can someone please help.

Query name: Query_BLB1

Would like tablename to be: BottomLineBalancing.

Thank you in advance for any assistance.
Click to expand...

just use an append or a make table query. DoCmd.OpenQuery...
I guess you just like making things difficult?
 
No...I don't like making things difficult. Perhaps you missed the 'crosstab'
portion of my previous post. I currently have a crosstab query designed but
I don't see a way to append the results or make a table from the query
without losing the design of the crosstab function. Someone in our company
created a procedure based on this crosstab query whereby we 'manually' import
the query as table within the current database. This table is then later
used in a macro. I'm just trying to figure out how to eliminate that manual
step and thus far can't work around the step of my original post.
 
No...I don't like making things difficult. Perhaps you missed the 'crosstab'
portion of my previous post. I currently have a crosstab query designed but
I don't see a way to append the results or make a table from the query
without losing the design of the crosstab function. Someone in our company
created a procedure based on this crosstab query whereby we 'manually' import
the query as table within the current database. This table is then later
used in a macro. I'm just trying to figure out how to eliminate that manual
step and thus far can't work around the step of my original post.
Click to expand...

did you try creating an append query based on your crosstab?
 
Back
Top