Ask Your Question
1

import csv data into database

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

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
0

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

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 45 times

Last updated: Jul 23