Connect to a MySQL database

Before you can connect to a MySQL database, you need the MySQL Connector on your computer. To install the MySQL Connector (Connector/Net), go to http://go.microsoft.com/fwlink/?LinkId=278885 and downloadConnector/Net 6.6.5 for Microsoft Windows. The driver bit-ness needs to match the Microsoft Power Query for Excel add-in installation (32-bit or 64-bit).

In the POWER QUERY ribbon tab, click From Database > From MySQL Database.
In the MySQL Database dialog box, in Server Name specify the MySQL Database Server to connect to.
Click OK.
If the MySQL server requires database user credentials:

In the Access a Database dialog box, enter your username and password.
Click Save.

이 게시물을...

첨부 :: mysql-connector-net-6.6.5.msi [File Size:12.73MB/Download:52]

조회 수 :: 45523
등록일 :: 2013.09.05; 12:15:51 (*.251.139.158)

엮인글 :: http://www.webs.co.kr/index.php?document_srl=24710&act=trackback&key=fcd

게시글 주소 :: http://www.webs.co.kr/index.php?document_srl=24710

List of Articles

번호	제목	글쓴이	조회 수	날짜
67	Oracle 10G installation	admin	37271	2011-12-13
67
66	Oracle 의 ASM 구조 알아보기..	admin	39875	2011-12-13
66
65	오라클 아키텍쳐	admin	36245	2011-12-13
65
64	Oracle ACE 로부터 배우기	admin	39327	2011-12-16
64
63	Oracle Preinstallation Tasks	admin	33536	2011-12-16
63
62	Oracle 의 ASM 구조 알아보기..	admin	40511	2011-12-16
62
61	Oracle 설치 Centos ,openSUSE,엔터프라이즈등 퍼온글	admin	36660	2011-12-16
61
60	xhost and display	admin	34893	2011-12-16
60
59	(C#) ASP.NET MySQL Check Already Exists Add/Insert Record 프로그래밍 코드	admin	34648	2011-12-19
59
58	Java && Excel 연동 JAVA 자바로 엑셀을 핸들링 할 수 있는 방법	admin	193012	2011-12-19
58
57	http://www.hoons.kr/	admin	34808	2011-12-19
57
56	Oracle Backup & Restore	admin	87866	2012-02-07
56
55	오라클 ACE가 해설하는 Oracle Backup & Recovery	admin	41302	2012-02-07
55
54	Oracle Backup & restore with RMAN 기본	admin	41995	2012-02-12
54
53	Oracle RHEL4+10G 10.2.0.1 설치 10.2.0.5 패치	admin	95163	2012-03-03
53
52	Upgrade Oracle 10g Release 2 from 10201 to 10204	admin	110798	2012-03-05
52
51	centos 6.2 oracle 10g 설치	admin	108648	2012-03-05
51
50	Upgrade Oracle from 10.2.0.1 To 10.2.0.4 (Windows)	admin	164510	2012-03-06
50
49	SUSE Linux Enterprise Server 10 (Oracle 10g R2 (10.2.0.1))	admin	37472	2012-03-09
49
48	Oracle 10g Articles	admin	32040	2012-06-24
48
47	기본 10g 설치의 리눅스 세팅에서 추가 해줘야하는 사항(윈도우)	admin	39481	2012-06-24
47
»	Connect Excel VBA to a MySQL database	admin	45523	2013-09-05
»	http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/ http://stackoverflow.com/questions/13558921/how-can-vba-connect-to-mysql-database-in-excel http://office.microsoft.com/en-us/excel-help/connect-to-a-mysql-database-HA1040198...
45	MySQL Java tutorial	admin	48500	2012-09-30
45
44	Configuring Oracle ASM disks in Oracle Enterprise Linux	admin	38282	2013-04-20
44
43	PreparedStatement mysql java 깔끔한설명	admin	105626	2013-10-26
43
42	Oracle Linux 에 Oracle DB 설치하기	admin	104575	2013-12-03
42
41	OLE5 + 11G 설치 _silent mode	admin	84217	2013-04-08
41
40	RHEL4 + 10g 설치 _silent mode	admin	81054	2013-04-08
40
39	OS에따른 Oracle 설치버전	admin	32046	2013-04-08
39
38	SUPER OCM 1.8club	admin	31069	2012-12-18
38

쓰기

첫 페이지 1 2 3 끝 페이지

네트워킹

Connect Excel VBA to a MySQL database

Connect to a MySQL database