 |
Caled
Sorcerer
Joined: 21 Oct 2000
Posts: 821
Location: Australia
|
 Posted: Sun Mar 09, 2003 12:59 pm
importing excel table, to database
|
I understand how databases work, and some of what they can do. I have very little experience at using them however...
I have a table in excel... 4 columns
Rune, Type, Literal and Interpretation
And over 300 entries (rows) under those. I want them in the database so I can run queries and stuff... and I want it in the zmud one, rather than in access (I could probably figure out the import process to access) because sometime in the future I'll be interested in some kind of semi-intelligent automatic translation thingy (we're creating a language).
But... I'm at a loss as to how to get the table into the database, without typing all 1200+ values in by hand... can anyone help me?
Oh, v. 6.40... and its excel 2000
Caled |
|
|
|
|
Drevarr
Beginner
Joined: 19 Dec 2001
Posts: 17
Location: USA
|
Posted: Mon Mar 10, 2003 1:10 am
|
Export your Excel file to a Tab or Comma delimited text file.
Open the Zmud database module, create a new database with four fields (Rune, Type, Literal, Interpretation).
Import your Tab or Comma delimted file.
look under View|Import in the DB window.
Make sure you assign each column to an appropriate DB field in step two of the process. |
|
|
|
|
kilthan
Wanderer
Joined: 21 Jan 2003
Posts: 76
|
Posted: Mon Mar 10, 2003 4:28 pm
|
You can just copy and paste it while in list view
|
|
|
|
|
Caled
Sorcerer
Joined: 21 Oct 2000
Posts: 821
Location: Australia
|
Posted: Mon Mar 10, 2003 8:51 pm
|
Actually, that put everything into a single cell, separated by what looked to be short fat double pipes.
But its cool - thanks Devarr, the importing thing worked fine, and now...I'm thwappng myself cos it was so simple.
Caled |
|
|
|
|
|
|
|
