Hi ~ I have an MFC application using automation that needs to open an access database, perform a query to get a recordset and then copy the recordset to Excel. I found an article on the microsoft site that explains how to do it, but I am getting an error = "The server threw an exception" The article is at: support.microsoft.com/kb/243394/en-us I am using Visual C++ 6.0 and Excel/Access 2003 (although my file is Access 2000 format). Any ideas on what I might need to do to fix it? Thanks so much for your help! Jen

Hi ~ I have an Excel Chart embedded in my program in a MFC Dialog. The x-axis scale shows dates from a time range selected by the user. The data is then drawn on the chart. My problem is that in some cases the x-axis scale is missing. With the same data and scale, the data sometimes appears. If I have it redraw 10 times, the data is there some of the time. Any ideas on what could be happening? Thanks in advance! Jen

Hi, I am using the DSOFramer control in an MFC dialog to display an excel chart. I have figured out how to run it and start with an excel worksheet and chart that I can modify to look how I want. Now I need two more tabs added (one with a worksheet and one with a chart)...I am using the following and it gives me an error that the Add function failed. COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); _Workbook wb; Worksheets wsSet; _Worksheet ws; LPDISPATCH lpDisp = m_FrameControl.GetActiveDocument(); wb.AttachDispatch(lpDisp); wsSet = wb.GetWorksheets(); ws = wsSet.Add(covOptional,covOptional,covOptional,COleVariant("Excel.Sheet")); Thanks in advance for your help! Jen

I am using the DSOFramer control to try in insert an Excel Chart into an MFC Dialog. I can get a chart with sample data to appear, but am not sure how to get my data into it or customize the graph. I have read the microsoft article explaining it, but need a little more help! Any info would be greatly appreciated! Thanks! Jen

Hi, Thanks for the link to the article. It was very helpful, and I now have a chart in my dialog. However, I can't seem to figure out how to put my data into the chart, and select an XY Scatter chart...Any info or code snippets would be really appreciated!! Thanks again!! Jen :)

Hi, I am trying to put a chart in an MFC Dialog. I was told that the best way was to use the Office Web Components and the Chart available through that (adding it by selecting ActiveX componenent). However, I'm not sure how to do it. When I add this control to my Visual C++ 6.0 Project, the program never starts. It gets stuck in a BindControls function. Does anyone know where I can get an example or article to help me out with this? Or a better way to graph a huge amount of data and display it in a MFC Dialog? Thanks so much! Jen

I am currently debugging a program that stores large amounts of data. Every 15 minutes 1000 pieces of data are calculated and written to a text file. This file is now 250 MB and getting very difficult to deal with. It crashes when opening, things crash when it is loaded, etc. Overall it was not written well. My job is to fix it, but I am not sure where to start. My coworkers have suggested splitting the file up so that every month a new file is generated, and only the last years worth of files are loaded, unless the user needs more. Another suggestion was using a binary file instead of text. Another suggestion was to convert the text file to a database. Someone thought that Access might not be able to handle a record with 1000 pieces of data. I have a lot of research to do, but I thought that this might help me in the right direction!! Any ideas you have would be greatly appreciated. Jennifer

Thank you for all the suggestions. I looked into CMemFile, but it said " Because CMemFile doesn't use a disk file, the data member CFile::m_hFile is not used and has no meaning." I read through the description and didn't see how to use it to read a large data file from disk. I also looked into writing the file a cluster at a time, but the problem is that my file is constantly growing (every 10 minutes it gets more information). So right now it is 600MB, but in a couple months it will be 800MB. What would the quickest way be to read a large file like this? Thanks! Jen

I am debugging a Visual C++ program, and my job is to speed up the file access. Currently the program is reading in a 600 MB ascii-text file using fopen and fscanf, etc., in text mode. Is there an easy way to speed this up? I have tried using streams and they aren't defined. Would changing it to binary make it faster? Thanks so much for your help! Jennifer