473,513 Members | 2,676 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Exporting Crosstabs

2 New Member
Hi,

I have a Crosstab query that I want to run on a daily basis, each day a column will be added with the date as a column headers. I want to automate this by use of a macro. Now the problem is that when you run a Crosstab it doesn't create a table (i.e it's like a Select query), hence you can't export by use of a macro, since you can only export tables as far as I know. Is there a way to export the resultant crosstab query, or copy the crosstab in to a table?
Thanks
Jun 21 '07 #1
2 1667
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi,

I have a Crosstab query that I want to run on a daily basis, each day a column will be added with the date as a column headers. I want to automate this by use of a macro. Now the problem is that when you run a Crosstab it doesn't create a table (i.e it's like a Select query), hence you can't export by use of a macro, since you can only export tables as far as I know. Is there a way to export the resultant crosstab query, or copy the crosstab in to a table?
Thanks
There is nothing to stop you exporting a query the same as you would a table.
Jun 22 '07 #2
Omarmn
2 New Member
Got it! thanks. In my macro I used TransferDatabase to transfer to a table, then I used to TransferSpreadsheet to exoprt it to into excel form. Now I can export it by use of a macro. Thanks.

I forgot to mention that I want to export it to excel :-p
Jun 22 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
9217
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
0
1255
by: RCS | last post by:
I have a crystal report which works fine in the Crystal design. The crosstabs display the summarized fields as horizontal, but when I run the same report in dotnet the crosstabs display the...
1
1936
by: Jacky11 | last post by:
I have a column name the Data type is MEMO The input is more than thousands of characters. When exporting, not all the information is exported. Who can I correct this problem? Thanks
2
1567
by: John Baker | last post by:
Hi: While the crosstabs capability appears very powerful, I don't see how I can get the information into a form or anything else. Is there some way I can do a cross tabs, and then use the...
2
7974
by: Kenneth | last post by:
How do I remove the limitation in Access that deny me from exporting 24000 rows and 17 columns (in a query) into Excel? Kenneth
1
3146
by: Mustufa Baig | last post by:
I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream...
2
2391
by: bienwell | last post by:
Hi, I have a question about exporting data from datagrid control into Excel file in ASP.NET. On my Web page, I have a linkbutton "Export data". This link will call a Sub Function to perform...
2
3159
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
5
7765
by: garethfx | last post by:
Hi all Ive 2 crosstab queries that I have been asked to export the data from to excel. My sql isn't to cleaver so I,m stuck. I need to place the queries outputted data into specific cells in...
0
981
lotus18
by: lotus18 | last post by:
Hello World! I have 2 crosstabs on my crystal report. My crosstabs are using only one table. But, I want my second crosstab to retrieve only distinct values. Is this possible? If not, my other...
0
7259
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7380
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7098
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7523
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4745
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3232
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3221
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1592
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.