RE: Dump Excel File to Database table

2004-02-04 Thread Paul Kraus
> Paul, > Thanks for your response. I'm open to any suggestion as I'm pulling my > hair > out trying to find out how to upload this data. My files can vary in > numbers > of rows and columns but the x and y axis always contain the same type of > metadata - in my case cost centre and cost item. A sa

RE: Dump Excel File to Database table

2004-01-28 Thread Paul Kraus
This may be off the mark but I have always found it easier to save the table as a csv file and use Text::CSV to then parse that. I always prefer working with text but that's me. HTH, Paul Kraus --- PEL Supply Company Network Administrator > -Original Message- > F