import csv data into database
Trying to create a database and I'd like to copy an existing csv file to populate it. How do I do this?
First time here? Check out the FAQ!
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?
Asked: 2019-07-22 06:59:53 +0100
Seen: 1,383 times
Last updated: Jul 23 '19
arabic language support [closed]
Any way to speed up database search? [closed]
Installation on Fedora 14 system fails. [closed]
converting perfect works data files [closed]
Where can I find sample databases for Base?
compatibility with microsoft access97 [closed]
How do you set up input for many-to-many intersections in Base? [closed]