Jika ada sedikit data dalam excel, mahu jadikan SQL query.
="INSERT INTO mg_senarai_laporan VALUES ('', '"& A1 &"', '"& B1 &"');"
Ms-Excel Cipta Query Bagi Data Berulang
Saturday, January 21, 2012
Subscribe to:
Posts (Atom)
ir a principal |
Ir a lateral
Abu Faaris M Firdaus
Menulis bukan untuk berkongsi ideologi, sekadar nota kecil buat bekal diri.
Labels
acrobat
(1)
actb
(1)
adobe
(1)
Ajax
(1)
alternatif
(1)
anchor
(1)
array
(13)
autosuggest
(1)
backup
(1)
bash
(2)
blog
(1)
c++
(1)
checkbox
(2)
code
(1)
country code
(1)
datepicker
(1)
decoding
(1)
decryption
(1)
encoding
(2)
encryption
(3)
Excel
(2)
file system
(1)
Freelancers
(1)
function
(2)
grep
(1)
hardware
(1)
html
(2)
HTML5
(1)
icon
(1)
isset
(1)
javascript
(8)
JQuery
(3)
kerajaan
(1)
kpdnkk
(1)
latitude
(1)
link
(2)
linux
(1)
Listing
(1)
longitude
(1)
Malaysia
(1)
MS-Office
(1)
mykiragst
(2)
myr
(1)
MySQL
(7)
mysql array
(1)
oracle
(4)
pagination
(2)
password
(1)
php
(30)
phpexcel
(2)
Portfolio
(1)
postfix
(2)
postgres
(3)
preg_match
(1)
Profile
(1)
Programmers
(1)
programming
(16)
progressbar
(1)
radiobutton
(1)
regex
(1)
relayhost
(1)
remove row
(1)
restore
(1)
select
(3)
sendmail
(2)
shorthand if else
(1)
sql
(6)
table
(1)
telefon
(1)
textarea
(1)
tips
(4)
trigger
(1)
umlet
(1)
visio
(1)
whatsapp
(1)
windows
(2)
write file
(1)
XP
(1)
yed
(1)
youtube API
(1)
(c)Ayus 2008 de Abu Faaris | Lawati web utama di Nursyuhada.com