Entry

How do I convert a file made in excel into a database?

Mar 15th, 2004 11:32
Matt Chatterley, Gloria Torres,

Only a brief answer, given the possiblities.
One of the easiest ways is to export the file from Excel as a CSV (comma
separated value) file, which can then be programatically parsed.
You could create a short PHP script (although any language could be used
for the task), which explodes the values out into an array, assigning a
column name to each index (i.e. 0 = columnA, 1 = columnB) and then
builds and executes a series of queries against the database to insert
the data.