RE: software na převod dat

[Jiří Vojtek]

Jestli to potrebujete jen jednorazove tak si od nas  #komerce www.cloveretl.com stahnete cloverETL designer

Trial je tusim na cca 30 dni  

Pro pripojeni na MS Access pouzijte   <https://wiki.javlin.eu/display/CONSULTING/UCanAccess+universal+pure+Java+MS+Access+JDBC+driver> UCanAccess universal pure Java MS Access JDBC driver ten jako jeden y mala funguje

Pak si namapujte co kam potrebujete a dbfwriter tam je primo

Kdyby Vam to nechodilo dejte vedet. Poresime

J.V.

 


sample connection file:


#Mon Jun 29 15:32:47 CEST 2015
user=
dbDriver=net.ucanaccess.jdbc.UcanaccessDriver
jdbcSpecific=MSACCESS
password=
name=AccessConnection
dbURL=jdbc\:ucanaccess\:///tmp/myfile.mdb;newdatabaseversion=V2010;singleconnection=true
jndiName=

 

The ';newdatabaseversion=V2010' will tell the driver to create new Access database file in case it does not exist.


Usage


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:

dbURL=jdbc\:ucanaccess\:///BCT/bin/sandboxes/OPMS_staging/data-in/vbWatchdog_Sample.mdb;memory=false

 

IMPORTANT
In default setting UCanAccess locks the db file "because of caching and efficiency needs". 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.

This can be solved by adding singleconnection=true parameter to the connection url.

Source:
 <http://sourceforge.net/p/ucanaccess/discussion/help/thread/4539a56c/> http://sourceforge.net/p/ucanaccess/discussion/help/thread/4539a56c/

 

 

 

 

 

From: Hw-list [mailto:hw-list-bounces na list.hw.cz] On Behalf Of Stanislav Svoboda
Sent: Friday, February 19, 2016 10:30 AM
To: HW-news
Subject: Re: software na převod dat

 

Zdravim,
neni lepsi exportovat data primo z Accessu?
Stanislav Svoboda

---------- Původní zpráva ----------
Od: Ondra hwnews <caha010 na gmail.com>
Komu: HW-news <hw-list na list.hw.cz>
Datum: 19. 2. 2016 15:33:02
Předmět: software na převod dat

 

Zdravím všechny, nemáte někdo náhodou free program na převod databáze z MDB 
do DBF ? Hledám už poměrně dlouho a nedaří se mi.

díky Ondra 

_______________________________________________
HW-list mailing list - sponsored by www.HW.cz
Hw-list na list.hw.cz
http://list.hw.cz/mailman/listinfo/hw-list

=

------------- další část ---------------
HTML příloha byla odstraněna...
URL: <http://list.hw.cz/pipermail/hw-list/attachments/20160219/7fecbc6c/attachment.html>