Importing Data to sql database from excel
Posted: Mon Mar 01, 2010 10:20 am
I have an sql database with a date field and I want to populate it with a large ammount of records from an excel spreadsheet.
Using phpMyadmin the only way I have found to import the data from the spreadsheet is by converting it to a csv file and then importing.
Unfortunately this method imports all the text fields correctly but the date field is imported as a series of zero's in the date format.
Does anyone know a way round this?
Thanks
Dave
Using phpMyadmin the only way I have found to import the data from the spreadsheet is by converting it to a csv file and then importing.
Unfortunately this method imports all the text fields correctly but the date field is imported as a series of zero's in the date format.
Does anyone know a way round this?
Thanks
Dave