Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confused
I am trying to insert a VFP table with an ADO Connection utilizing the
VFPOLEDB.1 driver. My SQL (being generated in excel/vba) is (excluding the semi-colons - there for Fox Pro Command window) INSERT INTO SY(; adp, aicalctype, aidaybasis, aidaycount, amortmeth, best, bloomberg, bridge, [carry], cbsycode, ; clcode, cnvcur, cnvinto, cocode, commrate, cpncur, cpnformula, cpnfreq, cpntype, cucode, ; cusip, derivative, euroclear, excode, excucode, feedquery, gensy2desc, gensycode, gensydesc, gensymbol2, ; gensymbol3, gsco, gscoprime, gsstcode, gssycode, idc, ilx, indgr, isin, isvarrate, ; lehm, login, merrin, moody, motc, msco, oldsycode, pikformula, preffeed, procucode, ; pscucode, quik, refundtype, remarks, reuters, rlbrcode, rlsycode, sacode, salesman, sedol, ; series, sgcode, shark, smcode, sncode, sp, [status], stcode, sycode, sydesc, ; [time], aifirstdt, aifirstset, announcedt, cnvfirstdt, cnvlastdt, cpnchgdt, cpnfirstdt, [date], expiredt, ; filedate, maturity, nextcalldt, nextputdt, syid, accreted, accretion, amortflag, contract, [convert], ; cxflag, dbtdefault, evwarning, ismethod, multchg, preferred, pricemult, reportchg, secfee, ; sygen, ; sygen2, uniqueid, accrerate, accrrate, amortfact, callprice, cnvprice, cnvratio, cpnchgrate, cpnrate, ; facevalue, fxrate, initprice, initsize, isfixrate, [margin], marketable, [mult], nfafee, notional, ; oshares, outshares, outstand, putprice, roundlot, strike) VALUES(; '65654', '', '360', '30', '', '', '61745P817', '', '', '', ; '', '', '', '', '', '', '', '', '', 'USD', ; '61745P817', '', '', 'NYSE', 'USD', '', '', '', 'IMB2', '', ; '', '', '', '', '', '', '', '', 'US61745P8178', 'N', ; '', 'SYMAN', '', '', '', '', '', '', '', 'USD', ; 'USD', '', '', '', '', '', '', '', '', '2459923', ; '', 'ZERO', '', 'CSH', '0001', '', 'A', 'STO', 'IMB2', 'MORGAN STANLEY INSD MUNI BD', ; '10:29', {}, {}, {}, {}, {}, {}, {}, {^2003-09-16}, {}, ; {}, {}, {}, {}, 0, .T., .T., .T., .T., .F., ; ..T., .T., .T., .T., .T., .F., 0, .T., .T., .F., ; ..T., .T.,0, .0000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ; 0.0, 0.0, 0.0, 0.0, 1.0, 1.0, 3, 1.0, 0.0, 0, ; 0, 0, 0.0, 0.0, 0, ; 0.0) And works fine in the Command Window. However it generates the old "Syntax Error" when running the VBA and executing. Any ideas would be appreciated as I have run into a gauntlet I belive. My Connex string is as follows: "Provider=VFPOLEDB.1;Data Source=\\<MACHINE_IP\PATH\DB.DBC;Mode=ReadWrite;E xtended Properties="";User ID=SYMAN;Password=SYMAN;Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=GENERAL All the datatypes work thus I am able to do the insert from the command win. ????? Perplexed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confused
NM
I got it myself. It wanted a full path to the dbf so instead of INSERT INTO SY use INSERT INTO \\machine\path\SY.dbf BTW yer all newbs LOL j/k "Ranmara" wrote in message ... I am trying to insert a VFP table with an ADO Connection utilizing the VFPOLEDB.1 driver. My SQL (being generated in excel/vba) is (excluding the semi-colons - there for Fox Pro Command window) INSERT INTO SY(; adp, aicalctype, aidaybasis, aidaycount, amortmeth, best, bloomberg, bridge, [carry], cbsycode, ; clcode, cnvcur, cnvinto, cocode, commrate, cpncur, cpnformula, cpnfreq, cpntype, cucode, ; cusip, derivative, euroclear, excode, excucode, feedquery, gensy2desc, gensycode, gensydesc, gensymbol2, ; gensymbol3, gsco, gscoprime, gsstcode, gssycode, idc, ilx, indgr, isin, isvarrate, ; lehm, login, merrin, moody, motc, msco, oldsycode, pikformula, preffeed, procucode, ; pscucode, quik, refundtype, remarks, reuters, rlbrcode, rlsycode, sacode, salesman, sedol, ; series, sgcode, shark, smcode, sncode, sp, [status], stcode, sycode, sydesc, ; [time], aifirstdt, aifirstset, announcedt, cnvfirstdt, cnvlastdt, cpnchgdt, cpnfirstdt, [date], expiredt, ; filedate, maturity, nextcalldt, nextputdt, syid, accreted, accretion, amortflag, contract, [convert], ; cxflag, dbtdefault, evwarning, ismethod, multchg, preferred, pricemult, reportchg, secfee, ; sygen, ; sygen2, uniqueid, accrerate, accrrate, amortfact, callprice, cnvprice, cnvratio, cpnchgrate, cpnrate, ; facevalue, fxrate, initprice, initsize, isfixrate, [margin], marketable, [mult], nfafee, notional, ; oshares, outshares, outstand, putprice, roundlot, strike) VALUES(; '65654', '', '360', '30', '', '', '61745P817', '', '', '', ; '', '', '', '', '', '', '', '', '', 'USD', ; '61745P817', '', '', 'NYSE', 'USD', '', '', '', 'IMB2', '', ; '', '', '', '', '', '', '', '', 'US61745P8178', 'N', ; '', 'SYMAN', '', '', '', '', '', '', '', 'USD', ; 'USD', '', '', '', '', '', '', '', '', '2459923', ; '', 'ZERO', '', 'CSH', '0001', '', 'A', 'STO', 'IMB2', 'MORGAN STANLEY INSD MUNI BD', ; '10:29', {}, {}, {}, {}, {}, {}, {}, {^2003-09-16}, {}, ; {}, {}, {}, {}, 0, .T., .T., .T., .T., .F., ; .T., .T., .T., .T., .T., .F., 0, .T., .T., .F., ; .T., .T.,0, .0000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ; 0.0, 0.0, 0.0, 0.0, 1.0, 1.0, 3, 1.0, 0.0, 0, ; 0, 0, 0.0, 0.0, 0, ; 0.0) And works fine in the Command Window. However it generates the old "Syntax Error" when running the VBA and executing. Any ideas would be appreciated as I have run into a gauntlet I belive. My Connex string is as follows: "Provider=VFPOLEDB.1;Data Source=\\<MACHINE_IP\PATH\DB.DBC;Mode=ReadWrite;E xtended Properties="";User ID=SYMAN;Password=SYMAN;Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=GENERAL All the datatypes work thus I am able to do the insert from the command win. ????? Perplexed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
confused in the o.c. | New Users to Excel | |||
Now I'm Really Confused | New Users to Excel | |||
Confused | Excel Worksheet Functions | |||
Very confused.... | Excel Discussion (Misc queries) | |||
Confused | New Users to Excel |