Hello @wblueg,
Please don’t get ahead of the process. As you can see, with some feedback on your part there is progress already.
You state you now have a csv file. This file should be opened in Calc. Open a new Calc file. Then select from menu File->Open
. Select your csv file & open it. This will bring up a Text Import
dialog. Make sure you data fields look OK then press the OK button. The data is now in the spreadsheet and at the top of each column hopefully is the name of each field.
Now open you new Base file. Make sure you have Tables section selected. Back to the Calc file.
Select ALL data on the sheet. Once selected, right mouse click & select Copy
. Back to the Base file.
In the blank tables section right mouse click & select Paste
. This brings up a copy dialog box. At the top make sure you have a table name you want. In the Options
section, insure Definition and data
and Use first line as column names
are selected. Click Create
button. Will get message to create a primary key - select Yes
.
If all has gone well you should have your database table.