473,289 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Export query result to an excel sheet

26
Hi Friends,

I have some code in an already built application.

Now the output pivots in .xls files is not matching with input data.

The output .xls has summarized results whereas , the input files has raw data.

Before the final output , many calculations are being done.
I have been told to debug.

What I need now is store the intermediate query results in temporary tables.

Dim sBasePivotSQL As String
Dim db As DAO.Database
Set db = OpenDatabase(sStagingDatabaseName)
sBasePivotSQL = db.QueryDefs("qryRisk").SQL

I want the query result in a temporay table.
So that after the application stops running , the temporary should be visible with the query data.

Secondly , if that temporay table data can be exported to a new excel sheet, I don't mind the temporay table being deleted, and I can see the data in the excel sheet.

Thanks in advance !!!

Moumita
Jun 1 '10 #1
1 2280
ADezii
8,834 Expert 8TB
@titli
Convert qryRisk into a Make Table Query, then Export those results.
Jun 1 '10 #2

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

Similar topics

14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
3
by: azzi2000 | last post by:
This should be rather simple. I have a query using different link tables and 2 parameters. The query works perfect. However I need to export or save the result in an Access table in order to...
2
by: awu | last post by:
All: I have a query that has 5 fields and around 15500 records. I need to save it to a excel file that has two sheets. First sheet saves all the 15500 records. Second sheet saves around 7500...
1
by: kannabiran | last post by:
Hi everyone.. Im new to this concetp, i having some records in the dataset now i want these records to exports to the excel sheet, with proper alignment with the header text..for example.. ...
3
jamjar
by: jamjar | last post by:
Trying to Export the results of a Query to Excel without having the user have to leave the Switchboard. Tried DoCmd.OpenQuery "myQuery" DoCmd.RunCommand acCmdExport DoCmd.Close...
1
by: bbawa1 | last post by:
have a GridView with data. I want to export this data to an excel sheet. How can I do that. Thanks in advance
1
by: DragonLord | last post by:
Does anyone know how I can Export the data loaded into a datareader into an excel spreadsheet. I would prefer vb.net code but I am alos well versed in C#. Any Help would be appreciated and...
3
by: AccessHunter | last post by:
Hi, I need to automate a process that would export a query to a text file, tab delimited. I know how to do it manually. Is there a way to automate the same? Please treat this as urgent. ...
2
by: jatin32 | last post by:
Hi, I have to export query result to EXCEL file in certain location. how do I do that? I have used DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , , , , acExportQualityScreen
5
xxoulmate
by: xxoulmate | last post by:
i wanted to export the query result into csv file is there any way to do it., e.g. select field1,field2 from table into csvfile
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

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.