SQL with excel

[expired user #11605]'s profile image [expired user #11605] posted 6 years ago in General Permalink

HOW could I import data of excel by the help of SQL to work effeciancly

[expired user #11657]'s profile image [expired user #11657] posted 6 years ago Permalink

Are you trying to import data into a database with HeidiSQL?

If so, open the excel file and save it as a csv file. You will want to make the data in the excel file as close to the tables format as possible, same columns, etc. Then in HeidiSQL, under the tools menu button, you will see a button "Import CSV file...". There are many options in the dialog that pops up, I won't cover them here.

I would create a test database, and test importing that excel file until get the format and settings correct before importing into your actual database.

abu's profile image abu posted 6 years ago Permalink

@naknak987 is there any way to import a csv so that a database table is generated on the fly, using csv 1st line headers as table field names?

[expired user #11657]'s profile image [expired user #11657] posted 6 years ago Permalink

No, that does not appear to be possible. You will need to setup your database table with the appropriate columns first.

Please login to leave a reply, or register at first.