1
2
3
4
5
6 package oscon2006.common;
7
8 import com.healthmarketscience.jackcess.*;
9 import org.apache.poi.hssf.*;
10 import org.apache.poi.hssf.usermodel.*;
11 import java.io.*;
12
13 public class xls2mdb
14 {
15 public static void main(String[] args)
16 {
17 if (args.length != 1)
18 {
19 exit("Sorry.");
20 }
21
22 File xlsFile = new File(args[0]);
23
24 if ( ! xlsFile.canRead())
25 {
26 exit("Sorry.");
27 }
28
29 try
30 {
31 String mdbFilename = getMdbFilename(xlsFile);
32 Util.createDatabaseFile(xlsFile, mdbFilename);
33 System.exit(0);
34 }
35 catch (Exception ex)
36 {
37 ex.printStackTrace();
38 }
39
40 }
41
42 public static String getMdbFilename(File xlsFile)
43 {
44 String dbFilename = null;
45
46 String xlsFilename = xlsFile.getName();
47
48 if (xlsFilename.toLowerCase().endsWith(".xls"))
49 {
50 dbFilename = xlsFilename.substring(0, xlsFilename.length() - 4) + ".mdb";
51 }
52 else
53 {
54 dbFilename = xlsFilename + ".mdb";
55 }
56
57 return dbFilename;
58 }
59
60
61 private static void exit(String message)
62 {
63 System.err.println(message);
64 System.exit(1);
65 }
66 }