Excel text field not taking big CString using VC++
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am inserting string into Excel file Using ADO .Execute fn(). It copies d first 3 records frm .txt file which r of size 20-30 char but as soon d 4th record which is 150 char long with special char is encountered it gives (((error:The field is too small to accept the amount of data you attempted to add.Try inserting or pasting less data..))) I manually changed the Format of Field frm text to General in Excel file and copy it so it worked but... how to go about programatically without changing from text to general the file format Codes: SQL.Format("INSERT INTO [Sheet1$] values('%s', '%s', '%s', '%s', '%s', '', '')", sJobName, sMID, sDT, sAN, sTitle); m_pConXLS->Execute(_bstr_t(sSQL), NULL, adCmdText); Thnx in Advance Casper2080