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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by vish6
-
Insert stmt takes lots of time
Hello I m using VB6.0 and Access. I have problem that it will take lots of time when i m going to insert for 1000 of records means it will take 4-5 min for 1000 records What i m doing is as follows. Excel sheet contains only 4 cols as empid,emppfno,empname and basic.while inserting in...- vish6
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
How To Convert Sql Server Join Query To Access
Hi I want to convert this sql server query in MS Access.It will work in sql server. So plz Tell me How to write it in Access. Update StockTable Set Outward=Outward-SM.Netweight,OutwardQty=OutwardQty-SM.Qty From Stocktable ST Join SalesVchMaterialDescCR SM on ST.Materialid=SM.Material_Name where...- vish6
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
