Import crosstab query as a table using code

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.
 
P

pietlinden

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?
 
L

LJP

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.
 
P

pietlinden

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help creating a search form in Access XP 0
Crosstab with subquery as source to another query 5
Access Lock File .LACCDB / Now shows as a notepad file 0
Table Security in Access 2013 1
pivoting query 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top