<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.6550" name=GENERATOR>
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 70.85pt 70.85pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
H1 {
FONT-WEIGHT: bold; FONT-SIZE: 24pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 9; mso-style-link: "Heading 1 Char"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
H3 {
FONT-WEIGHT: bold; FONT-SIZE: 12pt; MARGIN: 10pt 0cm 0pt; COLOR: #4f81bd; FONT-FAMILY: "Cambria","serif"; mso-style-priority: 9; mso-style-link: "Heading 3 Char"
}
H5 {
FONT-WEIGHT: normal; FONT-SIZE: 12pt; MARGIN: 10pt 0cm 0pt; COLOR: #243f60; FONT-FAMILY: "Cambria","serif"; mso-style-priority: 9; mso-style-link: "Heading 5 Char"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
P.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
SPAN.Heading1Char {
FONT-WEIGHT: bold; mso-style-priority: 9; mso-style-link: "Heading 1"; mso-style-name: "Heading 1 Char"
}
SPAN.Heading3Char {
FONT-WEIGHT: bold; COLOR: #4f81bd; FONT-FAMILY: "Cambria","serif"; mso-style-priority: 9; mso-style-link: "Heading 3"; mso-style-name: "Heading 3 Char"
}
SPAN.Heading5Char {
COLOR: #243f60; FONT-FAMILY: "Cambria","serif"; mso-style-priority: 9; mso-style-link: "Heading 5"; mso-style-name: "Heading 5 Char"
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
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 vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Diky vsem za prispevky, zda se ze mam vyreseno, MDB
Viewer Plus, neni jen prohlizec, ale umi i export.</FONT></DIV>
<DIV><FONT face=Arial size=2>Dokonce si muzu naklikat, ktery sloupce
chci.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ted uz jen vyresit cestinu, potrebuju to prekodovat
do Latin2.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=konference@vojtek.biz href="mailto:konference@vojtek.biz">Jiří
Vojtek</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=hw-list@list.hw.cz
href="mailto:hw-list@list.hw.cz">'HW-news'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, February 19, 2016 5:36
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: software na převod dat</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Trial
je tusim na cca 30 dni <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Kdyby
Vam to nechodilo dejte vedet. Poresime<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=CS
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">J.V.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<H5 style="MARGIN-TOP: 15pt; BACKGROUND: white; LINE-HEIGHT: 15pt"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #3d3d3d; FONT-FAMILY: 'Arial','sans-serif'">sample
connection file:<o:p></o:p></SPAN></H5>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">#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="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></P>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">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 id=UCanAccessuniversalpureJavaMSAccessJDBCdriver-Usage
style="MARGIN-TOP: 22.5pt; BACKGROUND: white; WORD-SPACING: 0px; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">Usage<o:p></o:p></SPAN></H3>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">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="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">dbURL=jdbc\:ucanaccess\:///BCT/bin/sandboxes/OPMS_staging/data-in/vbWatchdog_Sample.mdb;memory=false<o:p></o:p></SPAN></P>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></P>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><STRONG><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">IMPORTANT</SPAN></STRONG><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'"><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="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">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="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'">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="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></P>
<P
style="BACKGROUND: white; MARGIN-BOTTOM: 0pt; WORD-SPACING: 0px; MARGIN-LEFT: 0cm; LINE-HEIGHT: 15pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 7.5pt; orphans: auto; widows: 1; webkit-text-stroke-width: 0px"><SPAN
style="FONT-SIZE: 10.5pt; COLOR: #333333; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 5pt; MARGIN-BOTTOM: 5pt">
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>HW-list mailing
list - sponsored by
www.HW.cz<BR>Hw-list@list.hw.cz<BR>http://list.hw.cz/mailman/listinfo/hw-list<BR></BLOCKQUOTE></BODY></HTML>