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

zen --.. . -.

  • User 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 --.. . -.

  • User 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 --.. . -.

  • User 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 --.. . -.

  • User 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 --.. . -.

  • User 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,996
  • 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 07:00 - 22:00 Setiap Hari, Kecuali Hari Minggu (jika hari Minggu urgent bisa kontak via SMS)
Telegram:
@budi_s4n2s0, @owner_safana
WhatsApp:628112886854
Site : http://one.safana.co.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 --.. . -.

  • User 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

  • Full Member
  • ***
  • Posts: 834
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 Multipay

  • Reseller OtomaX
  • Hero Member
  • *****
  • Posts: 2,261
  • OtomaX Ultimate
    • 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
Telegram: @ryra_official
| www.ryracell.co.id Server Pulsa All Operator & PPOB Online

ircpulsa

  • User OtomaX --
  • Full Member
  • ***
  • Posts: 664
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

  • Full Member
  • ***
  • Posts: 808
  • *alskapulsa*
    • paket data kuoata murah
Re: Cara Import Data MS EXCEL dari MS SQL
« Reply #18 on: January 08, 2013, 12:13:50 PM »
ALHAMDULILLAH [attachment deleted by admin]  :'(

electriccell

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 181
  • 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 Sinar Peninjauan OKU
Telegram: @csfastpulsa CP: 081368106810 [WA]
Kantor : 0735-324507