Author Topic: Cara Import Data MS EXCEL dari MS SQL  (Read 18681 times)

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Cara Import Data MS EXCEL dari MS SQL
« on: October 06, 2009, 11:36:51 AM »
Bos-bos klo mo ambil data dari database MS SQL bisa dilakukan dgn langkah2 berikut:

1. Buka Excel, Klik Data-Import External Data- Import Data
2. Klik New Source

[attachment deleted by admin]
« Last Edit: October 06, 2009, 12:15:06 PM by zen »

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #1 on: October 06, 2009, 11:38:06 AM »
3. Sorot Microsoft SQL Server, Klik Next
4. Isi nama server, pada contoh berikut nama server= OTOMAX\SQLSERVER

[attachment deleted by admin]
« Last Edit: October 06, 2009, 12:15:32 PM by zen »

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #2 on: October 06, 2009, 11:38:43 AM »
5. Pilih data base Otomax
6. Pilih tabel yang akan diimport ke EXCEL, pada contoh dipilih tabel Reseller

[attachment deleted by admin]
« Last Edit: October 06, 2009, 12:15:48 PM by zen »

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #3 on: October 06, 2009, 11:39:20 AM »
7. Pilih tabel Reseller, kemudian klik Next
8. Berikan Deskripsi bebas utk memudahkan mengingat data yg akan diimport

[attachment deleted by admin]
« Last Edit: October 06, 2009, 12:16:03 PM by zen »

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #4 on: October 06, 2009, 11:40:52 AM »
9. Klik Open utk import tabel Reseller dari database Otomax MS SQL

[attachment deleted by admin]
« Last Edit: October 06, 2009, 12:16:18 PM by zen »

Budi Santoso

  • Dealer OtomaX
  • Sr. Member
  • ****
  • Posts: 1,993
  • Budi Santoso
Re: Cara Import Data MS SQL ke MS EXCEL
« Reply #5 on: October 06, 2009, 11:42:49 AM »
MANTAP JURAGAN... TUTOR nya...

Mungkin bisa di Balik kah...???

dari Ms. Excel ke Ms. SQL Server
SAFANA Corporation
IT Solution - Online Payment - General Payment


Jam Kerja Fix 08:00 - 21:00 Setiap Hari, Kecuali Hari Minggu (jika hari Minggu urgent bisa kontak via SMS)
Telegram:
@budi_s4n2s0, @owner_safana
WhatsApp:082137384444
BBM:5d088ca0
Site : http://safanacorporation.com/ - http://smartsoftware.web.id

NueBie

  • User OtomaX
  • Full Member
  • ***
  • Posts: 727
  • << NeuBie >>
Re: Cara Import Data MS SQL ke MS EXCEL
« Reply #6 on: October 06, 2009, 11:56:54 AM »
nais  ;D

red_dr4gon7

  • 0856 4002 8008
  • User OtomaX --
  • Sr. Member
  • ****
  • Posts: 1,782
  • < ".RAZIA." >
    • Software Isi Pulsa
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #7 on: October 06, 2009, 12:22:08 PM »
Nais Inpo Gan..  :-*  Lngsg di coba aahh..  :o
Br bgn tdr, puas2in,  ;D  cz besok ke Semarang..

Ce2net

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 223
  • Tommy "OtomaX" Gun
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #8 on: November 11, 2009, 11:06:58 AM »
Trim's bos sharing nya :D

abizalfa

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 409
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #9 on: November 16, 2009, 07:59:06 AM »
Mantap Gan
OID: CigLcVIrng_QhAjhbi99XEPr@@igpnEn8oNdMw

Jl. Flamboyan No. 3B Bendosari
Sanankulon - Blitar

Frostbite

  • Jr. Member
  • **
  • Posts: 150
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #10 on: April 04, 2010, 03:06:58 PM »
Makasih bgt ilmu nya...utk nambah2 kesaktian..hehe  ;D

iNDS

  • Newbie
  • *
  • Posts: 43
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #11 on: April 04, 2010, 05:51:52 PM »
Bos.. kalo kita mo import, otomax harus mati ya bos..?
O T O M A X   S T A N D A R T
OID: 894038680309fac3ca7ca596e53eca

zen --.. . -.

  • Dealer OtomaX
  • Full Member
  • ***
  • Posts: 876
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #12 on: April 04, 2010, 06:37:38 PM »
Bos.. kalo kita mo import, otomax harus mati ya bos..?

Gak bos... ;D

adiismanto

  • User OtomaX
  • Full Member
  • ***
  • Posts: 832
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #13 on: April 08, 2010, 05:31:16 PM »
3. Sorot Microsoft SQL Server, Klik Next
4. Isi nama server, pada contoh berikut nama server= OTOMAX\SQLSERVER

.\SQLexpress
Otomax user
Version : Ultimate 3.70
Backup UPS ICA 602B 1200 va plus acu 45AH x 2 bisa 8 jam
BBM : 5F015C54

wavecom

  • Newbie
  • *
  • Posts: 16
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #14 on: June 11, 2010, 02:28:37 AM »
9. Klik Open utk import tabel Reseller dari database Otomax MS SQL
gimana cara ya ga mundeng yang poin 9.

Nambahin dikit nih untuk tahu alamat server

START --> ALL PROGRAMS --> microsoft SQL SERVER 2005 --> SQL SERVER MANAGEMNET STUDIO EXPRESS



[attachment deleted by admin]

::ryra ceLL::

  • Reseller OtomaX
  • Sr. Member
  • ****
  • Posts: 1,204
  • OtomaX Ultimate 3.7.6
    • Server Pulsa All Operator & PPOB
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #15 on: September 18, 2010, 03:31:43 PM »
wauw........
Mangstab.....
Melayani Pembelian, Upgrade, Iuran Tahunan, Ganti Dongle, dan Balik Nama OtomaXTelp|SMS|WA : 085641234275 | 085270444555
Telegram: @ryraceLL | BBM : D54691EA
| www.ryracell.co.id Server Pulsa All Operator & PPOB Online
| www.ryrawebhost.com Domain, Hosting, Reseller, Web Design

ircpulsa

  • User OtomaX
  • Full Member
  • ***
  • Posts: 663
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #16 on: March 01, 2012, 06:40:28 AM »
wah kalo import data laporan ke MS EXCEL gemana ya???  ;) ;) ;) ;)
Indahnya Kebersamaan Walau jauh Terasa Dekat
SMS/Call : 085357275550 / 081977225999
Telegram : @ircpulsa
powered By otomaX

cs.rielzielreload

  • User OtomaX --
  • Newbie
  • *
  • Posts: 13
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #17 on: November 24, 2012, 05:21:45 PM »
5. Pilih data base Otomax
6. Pilih tabel yang akan diimport ke EXCEL, pada contoh dipilih tabel Reseller

[attachment deleted by admin]


maaaanttaaaab.............................
Alhamdulillah ........       :)

alaska

  • User OtomaX
  • Full Member
  • ***
  • Posts: 795
  • *alskapulsa*
    • Alaska Pulsa
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #18 on: January 08, 2013, 12:13:50 PM »
ALHAMDULILLAH [attachment deleted by admin]  :'(
add telegram cs : @csalaska21
http://www.alaskapulsa.com
MENGATASI MASALAH TANPA SOLUSI

electriccell

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 166
  • Maju terus
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #19 on: March 26, 2013, 07:56:46 AM »
mantab :)
12FASTpulsa
Jln. Komplek Pasar Sinarpeninjauan OKU
YM: cs_12fastpulsa, Hp: 081368106810
BB:D253C827