Ask Your Question

import csv data into database

asked 2019-07-22 06:59:53 +0100

lndcavanah gravatar image

Trying to create a database and I'd like to copy an existing csv file to populate it. How do I do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-23 04:09:40 +0100

lazarus477 gravatar image

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.

edit flag offensive delete link more


What to do if there is a lot of data and the copy/paste fails?

IMTheNachoMan gravatar imageIMTheNachoMan ( 2020-02-29 07:11:04 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2019-07-22 06:59:53 +0100

Seen: 1,383 times

Last updated: Jul 23 '19