import csv data into database

edit

First create a table in Base, to hold the data. For each column create a table field, set an appropriate data type and create primary keys, as required. Now open the CSV file in Calc. Select the cell range you wish to import and choose to copy it. Next, return to Base and right click the table and choose paste or paste special, depending on your needs.

That's about it.