Dear Bp Rachmat
Untuk di export ke sql memang tidak ada, atau bisa menggunakan append (tools di ms access) untuk memasukkan data dari ms access ke data ke sql (pk) auto increment, setelah di link odbc. Trims
Regards
Leo
On Saturday, 15 July 2017, 12:21, "Haer Talib haertalib@gmail.com [belajar-access]" <belajar-access@yahoogroups.com> wrote:
maksudnya seperti di MySQL ya, kita bisa bikin script SQL untuk mengcreate table lalu sekaligus mengisi table tersebut dengan data.
setahu saya dari Access langsung nggak bisa spt itu, nggak ada tools nya.
bisanya langsung migrasi databasenya (atau salah satu table) dari Access ke SQL Server atau ke MySQL, tapi bukan dengan membuat file .sql
Haer Talib
RumahAccess Indonesia
Tempatnya Belajar Microsoft Access
Artikel | Forum | Milis | Download | Training | Links | Blog | Event
2017-06-02 8:57 GMT+07:00 'Rachmat Solihin' rachmat.manunggal@yahoo.co.id [belajar-access] <belajar-access@yahoogroups.com>:
Pagi Para Experts,
Minta pencerahannya dong gimana caranya export table di Access ke File
berextention SQL.
Saya lihat di Menu Export hanya ada txt,csv dan xml.
Terima kasih.
Salam,
Rachmat Solihin
HRD Officer
PT. Manunggal Mitra Sahabat
Email : rachmat.manungal@yahoo.co.id
WA 0818907429
------------------------------ ------
Posted by: "Rachmat Solihin" <rachmat.manunggal@yahoo.co.id >
------------------------------ ------
SPAM IS PROHIBITED
------------------------------ ------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@ yahoogroups.com
belajar-access-fullfeatured@ yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@ yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/ us/yahoo/utos/terms/
__._,_.___
Posted by: leo <adityos2003@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar