And we need to go to the Exercise Files, chapter four, 04_01, and select makes.csv, and then click Open. And in the previous chapter, we created a makes table, so select that, and then select the Import tab. So we need to go to phpMyAdmin, and work with the database, it's up_and_running that we're working with. So there is that CSV file, it's now been exported from Excel. Clicking Don't Save means that no changes are made to the CSV file that we saved a moment ago. The reason is that if you click Save, Excel will try to create a workbook again.
"Want to save your changes to makes.csv?" Now, you might be tempted to click Save. To close this, I'm going to click that x up there, and then I get this warning from Microsoft Excel. And that's it, that's all you need to do. "Do you want to keep using that format?" Yes I do, so I just click Yes. And then I get this warning from Microsoft Excel, it says "Some features in your workbook might be lost "if you save it as CSV (Comma delimited). It says that it already exists, do I want to replace it? The answer is Yes. Select that, and Excel automatically changes the file name extention to. It's not those that you want, it's CSV (Comma delimited). There are a couple of other CSVs in here, CSV (Macintosh) and CSV (MS-DOS). Go to the File menu, select Save As, I'm going to save it in the current folder, and Save as type, we need to change that from Excel Workbook, by opening this dropdown menu, and selecting CSV (Comma delimited). It doesn't matter that they're not in alphabetical order even if I were to resort them, adding new makes later will result in the new makes being added at the end of the list. And underneath that are the names of all the car manufacturers.
And the first row contains "make," that's the name of the column. But let's take a look at the spreadsheet first. Now, it doesn't matter if you don't have access to Excel, because this folder also contains makes.csv, that's the CSV file that I'll be exporting from Excel. CSV stands for Comma Separated Values, and it's a common format for exporting data from a spreadsheet. PhpMyAdmin isn't capable of importing an Excel file directly, but that's not a problem, because it is capable of importing from a CSV file. In there is a file called makes.xlsx, that's an Excel file. And it's the chapter four folder that we need.
I've got the exercise files here on my desktop, so let's open that. In the Exercise Files for this video, there's a Microsoft Excel spreadsheet that contains the names of car manufacturers that I want to use in the makes table. Often, you have data stored in another format, such as a spreadsheet, so it's inconvenient to have to retype all the details manually into a database table.
0 kommentar(er)
