Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,198,776 members, 7,969,286 topics. Date: Tuesday, 08 October 2024 at 01:41 AM |
Nairaland Forum / JustJoined's Profile / JustJoined's Posts
(1) (of 1 pages)
Programming / Re: Test Your Knowledge Of Excel On This by JustJoined(m): 9:34am On Aug 02, 2008 |
This short script in Visual FoxPro might help **--------------This creates a folder on you c: drive for all the work m.DataDrive = 'c:' m.DataPath = '\nairaland' SET DEFAULT TO c: IF !DIRECTORY(m.DataDrive) MESSAGEBOX('Please make sure you have a C: drive mapped') QUIT ELSE IF !DIRECTORY(m.DataDrive+m.DataPath) MD nairaland CD nairaland ENDIF ENDIF **----------------Creates a temporary VFP table CLOSE ALL CREATE TABLE tmpDUMP FREE (fldName c(100), fldValue c(200)) **----------------Appends from excel sheet APPEND FROM ? TYPE XL5 SHEET sheet1 **----------------If the excel sheets are uniform and data placed same way in all the documents **----------------You can do this, DIMENSION rowval(RECCOUNT()) x = 1 GO TOP SCAN WHILE !EOF() rowval(x) = ALLTRIM(fldValue) x = x+1 ENDSCAN **------------------------You can do whatever you want here e.g. **------------------------Insert into SQL Server or reformat and export IF EOF() m.cnn = [DRIVER=SQL SERVER;SERVER=] + "127.0.0.1" + [;DATABASE=nairaland;uid=sa;pwd=nairaland] lnConnHandle=SQLSTRINGCONNECT(m.cnn) vSQL = "Insert Into dbo.nairalandSample (lastname,firstname,sex,age,country) Select "+"'"+rowval(1)+"','"+rowval(2)+"','"+rowval(3)+"','"+rowval(4)+"','"+rowval(5)+"'" =SQLEXEC(lnConnHandle,vSQL ,'xx') ENDIF |
Computers / Re: MTN Wireless Internet For Laptops? by JustJoined(m): 3:28pm On Oct 20, 2007 |
The MTN sharkpod, As a very mobile person I have had to acquire one and, these are my immediate comments, 1. It's okay for people who travel a lot and need to be online almost every time. I have been able to use it everywhere there is GPRS, Lagos, Ogun, Abuja, Enugu, Owerri, Ibadan, Ekiti to mention a few 2. It allows FTP and other basic functionality but does not allow remote desktop connection. 3. If you are paying as you use, you must be very buoyant. The flat N12k / month in my opinion is more economical. 4. I think it is slow but hey, I am able to connect to SQL Server over the net and pull down 100,000 records from a table with 10 fairly large fields. I hope this is helpful. |
Jobs/Vacancies / Two Web Designers Needed by JustJoined(m): 8:04pm On Oct 19, 2007 |
Two Creative Web Designers required. Renumeration between N720K and N1.4m per anum. Interested readers should leave their number(s) in the post and would be contacted. |
Nairaland / General / Re: Today Is My Birthday! by JustJoined(m): 12:16pm On Oct 14, 2007 |
I just joined and Today is my birthday too! Anyway happy birthday and thank you for reminding me that I am a year older today. |
(1) (of 1 pages)
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |