Wednesday, April 16, 2014

VBA Untuk Menyalin (Copy) Table Ke Database (.MDB) Lain

www.AstroDigi.comAstroDigi.com | Rabu, 16 Apr 2014 | Kalau pada artikel sebelumnya saya membahas mengenai cara menghapus record (isi tabel) dan juga cara menghapus tabel, maka pada artikel kali ini saya akan membahas mengenai cara menyalin (=meng-copy) tabel dengan perintah VBA.

Saya mulai dengan VBA untuk meng-copy tabel pada database sendiri yaitu:
'-------------------------------
Dim perintahSQL As String

perintahSQL = "SELECT tabelSumber.* INTO tabelBaru FROM tabelSumber"
DoCmd.SetWarnings False
DoCmd.RunSQL perintahSQL
DoCmd.SetWarnings True
'--------------------------------

Berikutnya adalah cara untuk meng-copy tabel ke DATABASE LAIN (file .MDB lain):
'-------------------------------
Dim perintahSQL As String

perintahSQL = SELECT tabelSumber.* INTO tabelBaru IN 'C:\namaDirektori\namaDatabase.mdb' FROM tabelSumber
DoCmd.SetWarnings False
DoCmd.RunSQL perintahSQL
DoCmd.SetWarnings True
'--------------------------------

Peng-copy-an tabel ini bisa dimanfaatkan untuk melakukan backup record dari suatu tabel ke database lain. atau bisa juga digunakan untuk memindahkan data ke database lain.

Selamat mencoba . . . have a nice day :-)

 www.AstroDigi.com (Nino Guevara Ruwano)

Comments :

20 comments to “VBA Untuk Menyalin (Copy) Table Ke Database (.MDB) Lain”

hollister, north face outlet, michael kors, montre pas cher, nike air max, beats by dre, rolex watches, soccer shoes, ugg boots, nike free, burberry, hermes, ghd, vans, herve leger, ferragamo shoes, yoga pants, mulberry, reebok outlet, supra shoes, oakley pas cher, lancel, abercrombie and fitch, karen millen, louis vuitton, asics, jimmy choo, new balance shoes, converse shoes, juicy couture outlet, mcm handbags, marc jacobs, hogan, chi flat iron, nfl jerseys, p90x, ralph lauren, birkin bag, valentino, timberland, air max, louis vuitton, lululemon, soccer jerseys, bottega, ray ban pas cher, insanity, celine handbags, wedding dresses, mont blanc

Coach Factory said...
on 

oakley sunglasses cheap, moncler, cheap sunglasses, ray ban, moncler outlet, ralph lauren, oakley sunglasses outlet, canada goose, louboutin, oakley sunglasses outlet, cheap oakley sunglasses, oakley sunglasses cheap, oakley vault, moncler, ugg, cheap sunglasses, cheap sunglasses, ugg boots, oakley vault, cheap oakley sunglasses, moncler, cheap oakley sunglasses, oakley vault, oakley outlet, oakley sunglasses outlet, cheap sunglasses, oakley sunglasses cheap, tn pas cher, oakley sunglasses outlet, oakley vault, ugg boots, oakley outlet, canada goose, oakley sunglasses cheap, gucci, canada goose, oakley vault, canada goose outlet, canada goose, canada goose outlet, cheap oakley sunglasses, cheap oakley sunglasses, oakley outlet, oakley sunglasses cheap, oakley, cheap sunglasses, oakley sunglasses outlet, oakley outlet

Coach Factory said...
on 

tiffany and co, oakley sunglasses, nike air max, michael kors outlet, louboutin, air max, coach factory, true religion outlet, michael kors, polo ralph lauren, kate spade outlet, true religion, coach factory outlet, prada handbags, nike shoes, oakley sunglasses, gucci outlet, tory burch outlet, air max, ray ban sunglasses, louis vuitton, oakley sunglasses, air jordan, nike free, louis vuitton outlet online, oakley sunglasses, coach outlet, louis vuitton handbags, coach outlet store, chanel handbags, michael kors, ralph lauren, true religion jeans, coach purses, longchamp outlet, michael kors outlet, ray ban sunglasses, polo ralph lauren outlet, louboutin, burberry outlet online, ray ban, oakley sunglasses, nike air max, nike free, toms shoes, burberry outlet online, prada outlet, jordan shoes, longchamp

Coach Factory said...
on 

ninest123 07.31
true religion jeans, oakley sunglasses, louboutin, michael kors outlet, michael kors outlet, coach outlet, longchamp outlet, tiffany jewelry, christian louboutin outlet, michael kors, kate spade outlet, prada handbags, ray ban sunglasses, gucci outlet, tiffany and co, replica watches, michael kors outlet, coach outlet, nike air max, polo ralph lauren outlet, louboutin shoes, ray ban sunglasses, tory burch outlet, michael kors outlet, jordan shoes, nike air max, oakley sunglasses, chanel handbags, coach purses, kate spade handbags, nike free, coach factory outlet, burberry, longchamp outlet, burberry outlet online, nike outlet, prada outlet, oakley sunglasses, polo ralph lauren outlet, longchamp, michael kors outlet, louboutin outlet

ninest123 Ninest said...
on 

true religion outlet, mulberry, lacoste pas cher, true religion jeans, nike air max, new balance pas cher, abercrombie and fitch, lululemon, hermes, nike blazer, longchamp pas cher, air force, vans pas cher, michael kors, nike free run uk, north face, sac guess, nike air max, air jordan pas cher, burberry, converse pas cher, north face, louboutin pas cher, nike air max, nike free, vanessa bruno, ralph lauren pas cher, sac longchamp, michael kors, ralph lauren uk, ray ban uk, air max, hollister, oakley pas cher, michael kors, hogan, tn pas cher, hollister pas cher, ray ban pas cher, nike roshe run, true religion jeans, timberland

ninest123 Ninest said...
on 

wedding dresses, soccer jerseys, nike roshe, abercrombie and fitch, iphone 6 cases, ferragamo shoes, reebok shoes, soccer shoes, ghd, asics running shoes, nike huarache, lululemon, vans shoes, instyler, nike roshe, oakley, insanity workout, p90x workout, mcm handbags, north face outlet, beats by dre, celine handbags, bottega veneta, baseball bats, north face outlet, longchamp, giuseppe zanotti, hollister, valentino shoes, new balance, nfl jerseys, hollister, jimmy choo shoes, babyliss, herve leger, mac cosmetics, birkin bag, timberland boots, chi flat iron, nike trainers, mont blanc, nike air max

ninest123 Ninest said...
on 

swarovski, replica watches, toms shoes, ugg boots, supra shoes, marc jacobs, montre pas cher, links of london, thomas sabo, vans, hollister, ugg pas cher, ugg,ugg australia,ugg italia, nike air max, ray ban, ugg boots uk, ugg boots, ugg,uggs,uggs canada, karen millen, gucci, bottes ugg, lancel, uggs on sale, ralph lauren, hollister, converse, wedding dresses, pandora charms, louboutin, juicy couture outlet, converse outlet, juicy couture outlet, pandora charms, swarovski crystal, ugg boots, coach outlet, pandora jewelry, ugg boots
ninest123 07.31

ninest123 Ninest said...
on 

polo ralph lauren, http://www.poloralphlauren.us.org/
celine outlet store, http://www.celineoutletus.com/
basketball shoes, http://www.basketballshoes.us.com/
pandora jewelry, http://www.pandorajewelryoutlet.us.com/
green bay packers jerseys, http://www.greenbaypackersjersey.us/
football shirts uk,soccer jerseys uk,cheap soccer jerseys uk
michael kors wallet, http://www.michaelkorswallet.net/
nba jerseys, http://www.nbajerseys.us.com/
oakley sunglasses, http://www.oakleysunglassesdiscount.us.com/
nike air force 1, http://www.airforce1.us.com/
north face jackets, http://www.thenorthfaceclearances.us.com/
oakley outlet online, http://www.oakleyoutlet.in.net/
hermes outlet online, http://www.hermesoutletstore.us.com/
oklahoma city thunder jerseys, http://www.thunderjerseystore.com/
mizuno running, http://www.mizunorunningshoes.us/
louboutin uk, http://www.christianlouboutinoutlet.org.uk/
ralph lauren polo shirts, http://www.poloralphlaurenshirts.us.com/
air jordan 13, http://www.airjordan13s.com/
michael kors outlet,michael kors outlet online,michael kors,kors outlet,michael kors handbags,michael kors outlet online sale,michael kors handbags clearance,michael kors purses,michaelkors.com,michael kors bags,michael kors shoes,michaelkors,cheap michael kors
dansko clogs, http://www.dansko-shoes.us/
the north face outlet, http://www.northface-outlet.cc/
the north face uk, http://www.thenorthfaces.org.uk/
kk0915

小 Gg said...
on 

marc jacobs
nike foamposite
vans shoes
calvin klein outlet
ralph lauren outlet
michael kors outlet online
swarovski crystal
ferragamo outlet
cheap nike shoes
michael kors handbags sale
oakley,occhiali oakley,oakley italia,oakley occhiali,oakley sunglasses
moncler outlet store
the north face outlet
michael kors factory online
ralph lauren uk
nike air max
asics,asics israel,asics shoes,asics running shoes,asics israel,asics gel,asics running,asics gel nimbus,asics gel kayano
longchamp outlet
michael kors wallet sale
michael kors outlet
mm1203

mmjiaxin said...
on 

ugg outlet
yeezy boost
oakley sunglasses,oakley outlet sunglasses
http://www.chromehearts.in.net
tiffany and co jewellery
Cheap NFL Jerseys China
tiffany jewellery
cheap real jordans
jordan retro
cheap oakley sunglasses
cheap tiffanys
cheap oakley sunglasses
kobe basketball shoes
air jordan retro
kobe shoes
oakley sunglasses wholesale
michael kors handbags
http://www.oakleystoreonline.us.org
tiffany and co outlet
michael kors outlet online
michael kors outlet

Chen Jeje said...
on 

michael kors outlet
uggs uk
oakley sunglasses
louboutin pas cher
michael kors handbags
ugg boots
cheap jordans
hollister clothing
louis vuitton
polo ralph lauren
michael kors outlet
retro jordans
abercrombie outlet
coach outlet store online
christian louboutin outlet
louis vuitton borse
oakley sunglasses
adidas originals shoes
canada goose coats
uggs on sale
michael kors handbags
kobe bryant shoes
fitflops sale clearance
mont blanc pens
true religion shorts
rolex watches outlet
replica watches
coach outlet
ugg boots
canada goose
los angeles clippers jerseys
louis vuitton handbags
coach outlet online
ralph lauren polo
coach factory outlet
kate spade handbags
ray ban sunglasses
toms shoes
louis vuitton paris
adidas shoes
chenlina20160902

chenlina said...
on 

fangyanting20161018
hollister sale
michael kors wallet
canada goose outlet
nike free running
nike trainers
mulberry sale
polo ralph lauren
michael kors outlet
tory burch outlet

fangyaoting said...
on 

ed hardy uk
michael kors uk
michael kors handbags
cheap nba jerseys
michael kors handbags wholesale
nike store uk
abercrombie and fitch kids
nike blazer
rolex replica watches
cheap ray ban sunglasses

raybanoutlet001 said...
on 

kate spade
michael kors outlet online
tory burch sale
birkenstock sale
ysl outlet store
cheap oakley sunglasses
pandora charms sale clearanc
uggs
canada goose parka
polo ralph lauren outlet
20161114yuanyuan

John said...
on 

coach outlet
louis vuitton outlet stores
coach outlet online
nike air force 1
toms outlet
burberry outlet
louis vuitton online
longchamp handbag
kobe shoes
ralph lauren
chanyuan2017.02.20

Unknown said...
on 

thomas sabo
louis vuitton neverfull
michael kors handbags
nfl jerseys wholesale
cheap oakley sunglasses
tiffany jewelry
michael kors outlet
mulberry handbags
toms shoes
ugg outlet
chanyuan2017.02.20

Unknown said...
on 

20170320 junda
polo ralph lauren
christian louboutin outlet
ugg outlet
swarovski crystal
oakley sunglasses
louis vuitton outlet
coach outlet clearance
nike outlet
coach outlet online coach factory outlet
cheap ray ban sunglasses

花无缺 said...
on 

new balance outlet
michael kors handbags
nike air huarache
ravens jerseys
bears jerseys
dolce and gabbana
replica rolex
browns jerseys
cheap jordans
michael kors outlet

Unknown said...
on 

fitflops sale clearance
michael kors outlet online
celine outlet store
nmd adidas
oakley sunglasses
cheap ray bans
christian louboutin sale
louis vuitton outlet online
ed hardy clothing
michael kors handbags
20170324huazhen

Meiqing Xu said...
on 

coach outlet store online
true religion outlet
adidas shoes
coach outlet store online
swarovski outlet
coach outlet clearance
nike blazer pas cher
coach factory outlet
jordan shoes
swarovski crystal
20170524ck

Gege Dai said...
on 

Post a Comment

Related Posts Plugin for WordPress, Blogger...