Excel spreadsheet

[Tyrone Baseck]

Some parts of this message have been removed. Learn more about Nabble's security policy.

I'm new to SQL but not Excel
I was given a Excel spreadsheet with Employee names.  I have a large
database with a Personal Table with Employee names and a whole list of
other tables that I'm used to running queries.  I'm still new to
queries.
 
I can run queries using the Pers_Table with employees and other
tables.  How can I import the Excel sheet and use it as the Pers table
with only the names of the 10 employees listed in the Mainframe export
of Employees.
 
My files:
Mainframe.xls for 10 mainframe users.
 
My tables:
Auth_id for user id's
CostCtr for Cost center codes
 
I'm attempting to do the above in MS Access.
Is there a way to do the above via SQuirreL SQL(an open-source Java
SQL Client program) on a DB2 database?
 
 

---

Time for vacation? WIN what you need. Enter Now!
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

On Thu, Jul 17, 2008 at 2:17 PM, Tyrone Baseck <tyrone_bak@...> wrote:

My files:
Mainframe.xls for 10 mainframe users.
 
My tables:
Auth_id for user id's
CostCtr for Cost center codes
 
I'm attempting to do the above in MS Access.
Is there a way to do the above via SQuirreL SQL(an open-source Java
SQL Client program) on a DB2 database?

Tyrone,

Assuming you want to import the names into the Auth_id table (which has a name column?), then you can use the dataimport plugin.  The plugin is optional, so you can download the installer and select it when it comes to optional plugins, if you didn't install it when you installed SQuirreL originally.  You can tell if it is installed by accessing the meny Plugin -> Summary and looking at the "Internal Name" column for "dataimport".  When it is installed, you can right-click on a table and select "Import File".  Point the file chooser at your excel spreadsheet and you can select the sheet and which columns to import from the spreadsheet into whichever columns of the table you desire.  It currently removes existing records from the table, so you may want to create a new table from scratch to import into.  It also supports auto-incrementing a count into a column (such as primary keys), if you choose.  You can map as many or as few columns from the spreadsheet as you desire, into whichever columns in the table you choose.  I was able to use it for DB2.  Let us know if you have problems.

Rob

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users