Installation and User Guide : (1.1beta)
1. Extract the distribution. It should create the follwoing folder structure and files -
2. Open EXCEL2DB.CMD in a Text Editor.
Edit the line
set JDBC_DRIVER=<JDBC DRIVER
LIBRARY>
Here you have to change the JDBC driver value as
appropriate. For example, if you are using Oracle database and the JDBC driver
for oracle classes12.jar is in folder C:\oracle\ora92\jdbc\lib then the JDBC_DRIVER value will be C:\oracle\ora92\jdbc\lib\classes12.jar
Save this file after updating the value.
3. Open config.properties in a text editor
Fill in values and Save this file. If you are unsure about the values, please go through the
README.TXT or QuickLoad Home Page http://quickload.sourceforge.net
Sample config.properties:
4. Open command prompt and go to the QuickLoad directory
5. Suppose you want to load an Excel File ..\address.xls
having the following content –
|
Last |
First |
Address |
City |
State |
ZIP |
|
Buffet |
Jimmy |
Somewhere
on the Beach |
Key West |
FL |
33040 |
|
Bush |
George |
1600
Pennsylvania Ave |
Washington |
DC |
20500 |
|
Cartman |
Eric |
84
Bigboned Way |
South
Park |
CO |
84214 |
|
Crockett |
Davey |
The Alamo |
San
Antonio |
TX |
78210 |
|
Doe |
Jane |
821
Zimbabwe Ave |
Washington |
DC |
20021 |
|
Gates |
Bill |
1
Microsoft Way |
Redmond |
WA |
98052 |
|
Jefferson |
George |
194
Deelux Apartments |
In the
Sky |
NY |
10041 |
|
Kong |
King |
Empire
State Building |
New York |
NY |
10118 |
|
Munster |
Herman |
1313
Mockingbird Lane |
Fargo |
ND |
58102 |
|
Rockne |
Knute |
146
Keenan Hall |
Notre
Dame |
IN |
46556 |
|
Simpson |
Homer |
742
Evergreen Terrace |
Springfield |
US |
12345 |
|
Smith |
Bob |
12 Main
Street |
Anytown |
IN |
46001 |
To load this type the following at the command prompt
excel2db.cmd config.properties
..\address.xls
and hit enter.
You will see the following output
Z:\Desktop\QuickLoad1.1rc1>excel2db
config.properties ..\address.xls
******************************************************
Usage - EXCEL2DB.CMD config.file
data.file [logfile] *
******************************************************
..\address.xls
Table(s): [QT_SHEET1ADDRESS_XLS]
Done.
QuickLoad created a table named QT_SHEET1ADDRESS_XLS for this XLS document.
You can see the table name in the logfile.
and inserted values from address.xls document.
*Snapshot
taken from SQL Tools software. (www.sqltools.net)
Well Done ;-)