Mungkin ini bisa membantu:
Working with External Data
You can use DAO to work with databases in different formats. There are three different categories of database formats that are accessible through DAO. The first type of format is the Microsoft Jet format. You can use DAO to work with all databases created with the Microsoft Jet database engine, including those created in Microsoft Access, Microsoft Visual Basic, Microsoft Visual C++�, and Microsoft Excel.
The second type of database format is the installable ISAM format. An installable ISAM is a driver that provides access to external database formats through DAO and the Microsoft Jet database engine. You must use your application's Setup program to install any installable ISAMs that you want to use. Installable ISAMs are loaded by Microsoft Jet when you refer to them in code. The individual database formats for which installable ISAMs are available include:
Microsoft FoxPro�, versions 2.0, 2.5, 2.6, 3.0 (read�only), and DBC
dBASE III, dBASE IV, and dBASE version 5.0
Paradox, versions 3.x, 4.x, and 5.x
Microsoft Excel version 3.0, 4.0, 5.0, 7.0, and 8.0 worksheets
Microsoft Exchange/Outlook
Lotus 1�2�3 WK1, WK3, and WKS spreadsheets
Delimited and fixed�width text files in tabular format
Tabular data in Hypertext Markup Language (HTML) files
The third type of database format that is accessible through DAO is the Open Database Connectivity (ODBC) data source. ODBC data sources, such as Microsoft SQL Server(tm) versions 4.2 and later, require an ODBC driver. Often an ODBC data source resides on a network server. ODBC is useful for developing client/server applications. The next section introduces two ways to work with ODBC data sources through DAO.
-----Original Message-----
From: siegfried [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 6:28 PM
To: [EMAIL PROTECTED]
Subject: [RantauNet] Mintak tolong
Assalamualaikum wR wB,
Maaf ambo kabatanyo saketek ka sanak-sanak nan suko komputer.
Ambo sadang mambuek program dengan bahasa Visual Basic, tapi
data yang ka di akses didalam format excell spread sheet. Apakah,
data yang didalam excell format ini bisa langsung dibaca oleh Visual
Basic? Bagaimanakah caranya? Ataukah harus di convert dulu ke
dalam format CSV atau txt?
Tarimo kasih sebelumnya.
Wassalam dan hatur nuhun pisan,
--fred
RantauNet http://www.rantaunet.com
=================================================
Mendaftar atau berhenti menerima RantauNet Mailing List di
http://www.rantaunet.com/subscribe.php3
ATAU Kirimkan email
Ke / To: [EMAIL PROTECTED]
Isi email / Messages, ketik pada baris/kolom pertama:
- mendaftar: subscribe rantau-net [email_anda]
- berhenti: unsubscribe rantau-net [email_anda]
Ket: [email_anda] = isikan alamat email anda tanpa tanda kurung
=================================================
WebPage RantauNet dan Mailing List RantauNet adalah
servis dari EEBNET http://eebnet.com, Airland Groups, USA
=================================================
