Trying to create a database and I’d like to copy an existing csv file to populate it. How do I do this?
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.
What to do if there is a lot of data and the copy/paste fails?