PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you're attending a SQLSaturday or thinking about hosting your own, we think you'll find it's a great way to spend a Saturday – or any day.
Visit http://www.sqlsaturday.com/ for more information.
On the March 24th, there will be one in the OC!
Saturday, March 17, 2012
Tuesday, February 28, 2012
Importing from Excel into myphpadmin
Have an excel file with the information. The excel file cannot have any additional information like labels or headers.
Save the file as
CSV
(MS-DOS)
In myphpadmin
select import
browse to the file
uncheck the box for partial import (we don't want a partial import)
change 'Fields terminated by' to a comma.
Save the file as
CSV
(MS-DOS)
In myphpadmin
select import
browse to the file
uncheck the box for partial import (we don't want a partial import)
change 'Fields terminated by' to a comma.
Subscribe to:
Posts (Atom)