₦airaland Forum

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

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.

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.

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.