nitintiwari
Last Activity: Nov 11 '06, 12:27 PM
Joined: Oct 8 '06
Location:
-
Excel File to MsSql by VB6
Pls can some one give me the code
I have a CurrentData.Xls file to be copied to a data base though mssql can some one giveme the code
I have a Database Name Medicine
CurrentData.xls have 10 Cols and around 2500 Rows how can i copy the excel file into dbf file in the Medicine Database pls give me the query and code
urgent -
How to get pass number varible in the sql query in where option
pls help
In Table X (Of MsAccess DAtabase)
Y = Numbers
Query = Select Z,Y from X where Y= ?
Wherever i pass a var in y it gives me data type mismatch error ]
pls help -
sSQL = "select Time ,bi from weather where TDate=date1
Correct Statement Should Be
varDate
varDate=10/10/2006
vardate=cdate(v ardate)
sSQL = "select Time ,bi from weather where TDate=#"& varDate &"#
happy codingLeave a comment:
-
nitintiwari started a topic How to code in VB6 to convert .xls file to .dbf and copy it to msaccess data basein Visual BasicHow to code in VB6 to convert .xls file to .dbf and copy it to msaccess data base
can some one help me with the above topic i want a code in vb6 to convert an excel file to be converted to msaccess file and copy the same file to my data base file
No activity results to display
Leave a comment: