<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
h1
{mso-style-priority:9;
mso-style-link:"Heading 1 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:24.0pt;
font-family:"Times New Roman","serif";
font-weight:bold;}
h3
{mso-style-priority:9;
mso-style-link:"Heading 3 Char";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold;}
h5
{mso-style-priority:9;
mso-style-link:"Heading 5 Char";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#243F60;
font-weight:normal;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.Heading1Char
{mso-style-name:"Heading 1 Char";
mso-style-priority:9;
mso-style-link:"Heading 1";
font-weight:bold;}
span.Heading3Char
{mso-style-name:"Heading 3 Char";
mso-style-priority:9;
mso-style-link:"Heading 3";
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold;}
span.Heading5Char
{mso-style-name:"Heading 5 Char";
mso-style-priority:9;
mso-style-link:"Heading 5";
font-family:"Cambria","serif";
color:#243F60;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jestli to potrebujete jen jednorazove tak si od nas #komerce <a href="http://www.cloveretl.com">www.cloveretl.com</a> stahnete cloverETL designer<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Trial je tusim na cca 30 dni <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Pro pripojeni na MS Access pouzijte <a href="https://wiki.javlin.eu/display/CONSULTING/UCanAccess+universal+pure+Java+MS+Access+JDBC+driver"><span style='color:#1F497D;text-decoration:none'>UCanAccess universal pure Java MS Access JDBC driver</span></a> ten jako jeden y mala funguje<o:p></o:p></span></p><p class=MsoNormal><span lang=CS style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Pak si namapujte co kam potrebujete a dbfwriter tam je primo<o:p></o:p></span></p><p class=MsoNormal><span lang=CS style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Kdyby Vam to nechodilo dejte vedet. Poresime<o:p></o:p></span></p><p class=MsoNormal><span lang=CS style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>J.V.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><h5 style='margin-top:15.0pt;line-height:15.0pt;background:white'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#3D3D3D'>sample connection file:<o:p></o:p></span></h5><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>#Mon Jun 29 15:32:47 CEST 2015<br>user=<br>dbDriver=net.ucanaccess.jdbc.UcanaccessDriver<br>jdbcSpecific=MSACCESS<br>password=<br>name=AccessConnection<br>dbURL=jdbc\:ucanaccess\:///tmp/myfile.mdb;newdatabaseversion=V2010;singleconnection=true<br>jndiName=<o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'> <o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>The ';newdatabaseversion=V2010' will tell the driver to create new Access database file in case it does not exist.<o:p></o:p></span></p><h3 style='margin-top:22.5pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px' id=UCanAccessuniversalpureJavaMSAccessJDBCdriver-Usage><span style='font-family:"Arial","sans-serif";color:black'>Usage<o:p></o:p></span></h3><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>You can use it as almost any other database connection, that is you can do DML, DDL and other SQL supported by regular MS Access database. When batch mode is enabled, it is able to insert 1M average long records in about 100s. For larger databases or when using too much RAM, use ";memory=false" at the end of connection string:<o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>dbURL=jdbc\:ucanaccess\:///BCT/bin/sandboxes/OPMS_staging/data-in/vbWatchdog_Sample.mdb;memory=false<o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'> <o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><strong><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>IMPORTANT</span></strong><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'><br>In default setting UCanAccess locks the db file <em><span style='font-family:"Arial","sans-serif"'>"because of caching and efficiency needs"</span></em>. What this means is that the file can't be e.g. deleted until you shut down server/runtime. If you manipulated with the connection in Designer (validation/browsing...), the file is locked by Designer too.<o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>This can be solved by adding <strong><span style='font-family:"Arial","sans-serif"'>singleconnection=true</span></strong> parameter to the connection url.<o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'>Source:<br><a href="http://sourceforge.net/p/ucanaccess/discussion/help/thread/4539a56c/"><span style='color:#326CA6'>http://sourceforge.net/p/ucanaccess/discussion/help/thread/4539a56c/</span></a><o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'> <o:p></o:p></span></p><p style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;line-height:15.0pt;background:white;orphans: auto;text-align:start;widows: 1;-webkit-text-stroke-width: 0px;word-spacing:0px'><span style='font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Hw-list [mailto:hw-list-bounces@list.hw.cz] <b>On Behalf Of </b>Stanislav Svoboda<br><b>Sent:</b> Friday, February 19, 2016 10:30 AM<br><b>To:</b> HW-news<br><b>Subject:</b> Re: software na převod dat<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Zdravim,<br>neni lepsi exportovat data primo z Accessu?<br>Stanislav Svoboda<o:p></o:p></p><p>---------- Původní zpráva ----------<br>Od: Ondra hwnews <<a href="mailto:caha010@gmail.com">caha010@gmail.com</a>><br>Komu: HW-news <<a href="mailto:hw-list@list.hw.cz">hw-list@list.hw.cz</a>><br>Datum: 19. 2. 2016 15:33:02<br>Předmět: software na převod dat<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Zdravím všechny, nemáte někdo náhodou free program na převod databáze z MDB <br>do DBF ? Hledám už poměrně dlouho a nedaří se mi.<br><br>díky Ondra <br><br>_______________________________________________<br>HW-list mailing list - sponsored by <a href="http://www.HW.cz">www.HW.cz</a><br><a href="mailto:Hw-list@list.hw.cz">Hw-list@list.hw.cz</a><br><a href="http://list.hw.cz/mailman/listinfo/hw-list">http://list.hw.cz/mailman/listinfo/hw-list</a><o:p></o:p></p></blockquote><p class=MsoNormal>=<o:p></o:p></p></div></body></html>