如何添加含有很多数据的一条记录

我要向一个表中存入一天的降雨量数据，每十分钟就是一个数据，一天24小时就是一条记录，有144个数据，我的
rainfall表中就至少有144列；在VC中利用SQL语句插入存储；编译时候提示string too big,就是strSQL中不能放这么多字符串，请教各位高手怎么解决这个问题，或者怎么来重新设计我的数据库，谢谢！
strSQL.Format("INSERT INTO Rainfall (Equipment_ID,Monitor_Time,Day_Rainfall,Rf_zerozero,Rf_zeroten,Rf_zerotwenty,Rf_zerothrity,Rf_zerofourty,Rf_zerofifty,\Rf_firstzero,Rf_firstten,Rf_firsttwenty,Rf_firstthrity,Rf_firstfourty,Rf_firstfifty,Rf_twozero,Rf_twoten,Rf_twotwenty,Rf_twothrity,Rf_twofourty,Rf_twofifty,\ Rf_threezero,Rf_threeten,Rf_threetwenty,Rf_threethrity,Rf_threefourty,Rf_threefifty,Rf_fourzero,Rf_fourten,Rf_fourtwenty,Rf_fourthrity,Rf_fourfourty,Rf_fourfifty,\ Rf_fivezero,Rf_fiveten,Rf_fivetwenty,Rf_fivethrity,Rf_fivefourty,Rf_fivefifty,Rf_sixzero,Rf_sixten,Rf_sixtwenty,Rf_sixthrity,Rf_sixfourty,Rf_sixfifty,\ Rf_sevenzero,Rf_seventen,Rf_seventwenty,Rf_seventhrity,Rf_sevenfourty,Rf_sevenfifty,Rf_eightzero,Rf_eightten,Rf_eighttwenty,Rf_eightthrity,Rf_eightfourty,Rf_eightfifty,\ Rf_ninezero,Rf_nineten,Rf_ninetwenty,Rf_ninethrity,Rf_ninefourty,Rf_ninefifty,Rf_tenzero,Rf_tenten,Rf_tentwenty,Rf_tenthrity,Rf_tenfourty,Rf_tenfifty,\ Rf_elezero,Rf_eleten,Rf_eletwenty,Rf_elethrity,Rf_elefourty,Rf_elefifty,Rf_twezero,Rf_tweten,Rf_twetwenty,Rf_twethrity,Rf_twefourty,Rf_twefifty,\ Rf_thrzero,Rf_thrten,Rf_thrtwenty,Rf_thrthrity,Rf_thrfourty,Rf_thrfifty,Rf_fouzero,Rf_fouten,Rf_foutwenty,Rf_fouthrity,Rf_foufourty,Rf_foufifty,\ Rf_fifzero,Rf_fiften,Rf_fiftwenty,Rf_fifthrity,Rf_fiffourty,Rf_fiffifty,Rf_sitzero,Rf_sitten,Rf_sittwenty,Rf_sitthrity,Rf_sitfourty,Rf_sitfifty,\ Rf_sevzero,Rf_sevten,Rf_sevtwenty,Rf_sevthrity,Rf_sevfourty,Rf_sevfifty,Rf_eigzero,Rf_eigten,Rf_eigtwenty,Rf_eigthrity,Rf_eigfourty,Rf_eigfifty,\ Rf_ninzero,Rf_ninten,Rf_nintwenty,Rf_ninthrity,Rf_ninfourty,Rf_ninfifty,Rf_twtyzero,Rf_twtyten,Rf_twtytwenty,Rf_twtythrity,Rf_twtyfourty,Rf_twtyfifty,\ Rf_twonezero,Rf_twoneten,Rf_twonetwenty,Rf_twonethrity,Rf_twonefourty,Rf_twonefifty,Rf_twtwozero,Rf_twtwoten,Rf_twtwotwenty,Rf_twtwothrity,Rf_twtwofourty,Rf_twtwofifty,\
Rf_twthrzero,Rf_twthrten,Rf_twthrtwenty,Rf_twthrthrity,Rf_twthrfourty,Rf_twthrfifty) \
VALUES('%s','%s',%f,  %f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,\%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,\
%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f,%f)",\EquipmentID,MonitorTime,raindaytofl,raindayminfl[0],........);