How do I import a spreadsheet into a db?
Posted on 2003-11-15
How do I import an Excel spreadsheet into a phpMyAdmin type of database? I see an export tab, but no import tab.
My db has an autoincrement as the first field, and a autodate/timestamp field. Do I need blank columns in my spreadsheet, one at the beginning and one in the middle of the spreadsheet, to correspond to those two fields too?
The last 3 fields in my db are not used at this time; do they need to be removed for the import to happen properly?
As you can tell, I'm not a programmer so please answer clearly, simply and in detail - it would be better to assume I don't know anything about this. My spreadsheet I'm trying to import goes from column A to columnAB (28 columns) and is 43,890 rows long. Do I need a special script, or do I just need to find the correct tabs and commands to click?
Should the spreadsheet file be saved as a xls or txt or some other format for the import?
Thank you for your help.