Stack Overflow
Stack Overflow

Questions tagged [jackcess]

Jackcess is a pure Java library for reading from and writing to MS Access databases

Jackcess is a Java library providing read/write support for Access database versions 2000 through 2010(+), and read-only support for Access 97 files.

It provides interfaces to open an existing database, iterate over contained tables and read information from the rows in the table. It also allows to create new tables and populate data in them.

Additionally it has functionality to import data from and sources. Separately available extensions allow to read encrypted files.

130 questions
0
votes
1 answer

Java - Jackcess API with .accde(MS Access) format

is it possible to read .accde format file from jackcess API?if yes, sample code or syntax please. The below code works with .accdb format. public Database getDatabase() { Database db; try { String accessFileName =…
vsr
  • 45
  • 7
0
votes
1 answer

how to open .mdb from ftp location jackcess

hi all with this code i can successfully download allpg.mdb and displaying... now i want to save the downloaded file to c:/folder.... if i edit dbTempFile = File.createTempFile("dbTempFile",".mdb"); to dbTempFile =…
H4SN
  • 1,482
  • 3
  • 24
  • 43
0
votes
2 answers

checking an access file via java and mailing for a specific row

I need to write a program that checks a access .mdb file and when a specific row is added (say the "name" field column of the newly added a row that contains a specific string, it should send an email to a specific address. For this I am planning to…
Hellnar
  • 62,315
  • 79
  • 204
  • 279
-1
votes
2 answers

How to solve NumberFormatException?

I'm kind of new with Java, so bear with me... I'm trying to write data from a CSV-file to an Access database using the Jackcess library. The first line of the CSV-file is written perfectly to the database, but from the second line on, it keeps…
HaroldFinch
  • 31
  • 7
-1
votes
2 answers

How To Read .MDB files in scala

I have task to convert .mdb files to .csv files. with the help of the code below I am able to read only one table file from .mdb file. I am not able to read if .mdb files contains more than one table and I want to store all the files individually.…
Pravinkumar Hadpad
  • 109
  • 1
  • 1
  • 10
-1
votes
1 answer

ucanaccess weird exception i cannot handle

I started using ucanaccess lately for connection to access database (obviously) and it all worked fine until now. I'm starting to insert about 500,000 rows into the database.... when I reach about 400,000 the program stops.... the problem is I cant…
Bar Hoshen
  • 302
  • 1
  • 18
-1
votes
1 answer

Cannot use data types with jackcess to export DB to csv

So I have a program that selects a DB and exports it as a csv. It appears when I export the DB the tab delimitation does not keep any data types. The csv ideally should keep text fields as "####","##" instead of just ####,##. Although the fields are…
snowflake
  • 55
  • 5
-1
votes
1 answer

UCanAccess driver throws Exception when trying to connect with Access database while Jackcess connection works fine

1) This UCanAccess sample code works with database A (Access 2000) Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); Connection conn = DriverManager.getConnection(DATABASE_URL); System.out.println(conn); 2) The same…
Andreas M. Oberheim
  • 873
  • 9
  • 7
-1
votes
1 answer

Reading an Access DB with Jackcess library

this is my first time trying to do this... I am trying to just get a link to my DB and then display a table to see if the link is established. For some reason it just doesn't work. Here is my code: package dbtest; import java.io.*; import…
ou_snaaksie
  • 28
  • 2
  • 8
-1
votes
1 answer

Reading an Access calculated field from Java on any OS (not just Windows)

How can I read calculated fields with UCanAccess or Jackcess (or any Java library that also works on Linux)? I don't care if I can't get the result straightaway, I'll settle for just getting only the function if need be. For simplicity, we'll…
user3037710
  • 11
  • 3
1 2 3
…
8
9