saving the data read by the client from a server.

Question

0.00/5 (No votes)

See more:

I have client-server program written in c++ in visual studio, I have a function defined in that to connect to a server, read data sets, data model etc. I run the program it connects to server and it displays output on a command prompt as it is an exe . How do I send these data that are displayed on cmd prompt to a excel file using odbc or by any other means??
I am not a expert in this field. Any help thru code, link or steps would be of great help to me.

Posted 30-Mar-15 1:58am

Member 11553536

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Accepted Answer · 2015-03-30T02:19:00

Solution 1

There is an old article here: Creating Excel Sheets using ODBC[^]. It uses the MFC CDatabase class to write Excel files using ODBC.

I prefer using ADO (OLE DB) instead of ODBC. It allows passing data by values rather than by text which is especially useful with floating point values to avoid rounding errors. This does not require MFC but is more complex than using SQL commands only as with ODBC. Article: How to Read and Write Excel Files in C++ via ADO[^].

As an alternative you may create a CSV, TAB separated text, or HTML file. All these formats can be loaded by Excel.

Posted 30-Mar-15 2:19am

Jochen Arndt

Comments

Member 11553536 30-Mar-15 8:32am

Thanks a lot for such quick reply. I will try it and if there is any question I will ask again.

Member 11553536 30-Mar-15 8:35am

// Insert data
sSql = "INSERT INTO demo (Name,Age) VALUES ('Bruno Brutalinsky',45)";
database.ExecuteSQL(sSql);

sSql = "INSERT INTO demo (Name,Age) VALUES ('Fritz Pappenheimer',30)";
database.ExecuteSQL(sSql);

sSql = "INSERT INTO demo (Name,Age) VALUES ('Hella Wahnsinn',28)";
database.ExecuteSQL(sSql);

In this part of the code , we are feeding the data. I want to this data to be fed directly from the data sent by server. I am not sure if I am clear with my question .

Jochen Arndt 30-Mar-15 8:42am

What I understand:
You have a client program that receives data from a server and prints the data to the console. Now you want to write the data to an Excel file.

If that is not what you want, you should refine your question.

Member 11553536 30-Mar-15 8:46am

Exactly that's my question. But in the above commands we are not taking the data from server , we are writing it manually, isn't it??

Jochen Arndt 30-Mar-15 8:56am

I don't see the problem. Before you can write data, you must get them from the server. You are actually printing the data to the console. So just replace that with writing to file (or perform both operations).

Member 11553536 1-Apr-15 9:22am

ok. I am going to ask a very silly question ,please bear with me. The whole client program is written with files having .c extension and now when I try adding this code it gives lot of cmath error as it is not in c. I fail to add it to my client, tried including cmath, math.h also changing the extension but of no help. I am totally a newbie with very basic knowledge of c and c++. I only into add this to my existing project and insert data read into this excel files. Don't know how to go about it!!

Jochen Arndt 1-Apr-15 9:53am

The ODBC method from the link requires MFC (as mentioned in my answer) which is C++. So you can't use it if you you are fixed to use C. The OLE DB method can be used with C but you will probably not find C examples (but most examples have not much C++ specific parts).

I suggest to convert your existing project to C++ (without the Excel output as first step). It may compile without errors after renaming all source files from .c to .cpp (but enable all warnings and check also the warnings). While it is possible to have projects with mixed C and C++ source files, I would not do so (especially as beginner).

If you have specific problems with the conversion you may raise new questions.

Member 11553536 2-Apr-15 9:40am

std::string makeConnStr(std::string filename, bool header = true)
CString cs(makeConnStr.c_str());
{
strstream.str().c_str().stream;

std::string hdr = header ? "YES" : "NO";
CString cs(hdr.c_str());

if (!filename.empty())
if (*--filename.end() == 'x')
{
printf("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\n", filename);

printf("Extended Properties=\"Excel 12.0 Xml;HDR=\n", hdr);
}
else
printf("Provider='Microsoft.JET.OLEDB.4.0';Data Source=\n", filename);

printf(";Extended Properties=\"Excel 8.0;HDR=\n", hdr);

return stream.str();
}

std::string sqlSelectSheet(_bstr_t connStr, int sheetIndex)
CString cs(sqlSelectSheet.c_str());
{
_ConnectionPtr pCon = NULL;
_RecordsetPtr pSchema = NULL;

TESTHR(pCon.CreateInstance(__uuidof(Connection)));
TESTHR(pCon->Open(connStr, "", "", NULL));

pSchema = pCon->OpenSchema(adSchemaTables);

for (int i = 0; i < sheetIndex; ++i) pSchema->MoveNext();

std::string sheetName = (char*)(_bstr_t)pSchema->Fields->GetItem("TABLE_NAME")->Value.bstrVal;
CString cs(sheetName.c_str())

strstream.str().c_str().stream;

printf("SELECT * FROM [\n", sheetName"]");
return stream.str();
}

AM I on the right track?

Jochen Arndt 2-Apr-15 9:45am

Code posted in a comment is hard to read. I suggest to open a new question.

What should the printf statements do? They print to the console but you probably want to create a connect string.

CPallini 30-Mar-15 8:54am

5.