Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viasual C++: Excel - ODBC - SQL Insert statement

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Hi,

I'm using Excel with ODBC to export data from a Visual C++ program ( + MFC ) and have a little problem:

In the most Cells in Excel the received data ist marked as following: '50
Problem: This is not coming from Excel, but from my program ! What I need is that if the transported value is an INTEGER it has to be an INTEGER in Excel too, but it does not work !
example for the INSERT statemnet: INSERT INTO table ( name, count ) VALUES ( 'Derek', 50);

The count Cell now shows '50 and that's a big problem for me !

Sorry for my bad english, ( coming from germany )
regards,
SAM
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top