Dave's Personal Blog.

4

Nov

HeidiSQL Convert CSV to SQL Importing the CSV file

Posted by Dave Dugdale Published in Coding

In Excel ‘Save As’ the spreadsheet to a CSV first.

heidisql-import-csv

heidisql-import-2

Make sure the csv columns are named the same as what you have in the database table.

I found this post on this topic very useful.

Related Articles

TotalFark Users Anti-Microsoft? Maybe Yes? (December 3rd, 2009)
Making Google Maps Look Like Google Analytics Map (September 16th, 2009)
Anonymous Proxy at AnchorFree Nigeria (August 11th, 2009)
Upgrading Wordpress File Permissions on CrystalTech (August 10th, 2009)
An error occured while Parsing an XML document. The element type “meta” must be terminated by the matching end-tag (July 9th, 2009)

No user responded in this post

Subscribe to this post comment rss or trackback url

Leave A Reply

Dave Dugdale

This is my personal blog, this is where I write random thoughts.

Contact Dave | About Dave

Search

Dave with a Camera

What's Dave Doing Now?

Follow Dugdale on Twitter.com

Recent Comments

rince in Google: Account temporarily disabled
sasikrishna in Google: Account temporarily disabled
Dave Dugdale in Upgrading Wordpress File Permissions on CrystalTec…
snekse in Upgrading Wordpress File Permissions on CrystalTec…
HP Mini 311-1025NR HDMI Review Proc… in My Conversation With Mirillis Splash AVCHD Player …
Gazelle in Creative Commons Requires a DoFollow Link?
Dave Dugdale in Creative Commons Requires a DoFollow Link?
Maksym in Creative Commons Requires a DoFollow Link?
Dave Dugdale in Creative Commons Requires a DoFollow Link?
Dave in Creative Commons Requires a DoFollow Link?

Categories

Meta

Log in

© 2010 Dave Dugdale - Author Dave Dugdale - Privacy