At 08:48 04/12/2017 -0700, John Buono wrote:
I am trying to import a CSV file into a database. I have followed
help page but it does not work.
No-one can be sure exactly what help instructions you have followed
unless you identify them, of course.
I open the CSV file and it opens correctly in a spreadsheet. But
then when I copy and paste the rows and columns into the database
table, all I get is the last value of the CSV file in the first cell
of the database.
I'm not sure exactly what you mean by pasting into the database
table. I see nothing in the help text about pasting *into a table*.
What am I doing incorrectly?
You may be making this too complicated.
o Create that database. You've done this.
o Open the CSV file in OpenOffice as a spreadsheet. You've done this.
o Either:
+ Copy the material from the spreadsheet.
+ In the database, click Tables in the Database column on the left.
+ Paste not into an existing table, but into the Tables panel now
visible in the database.
+ Follow the instructions from the wizard.
o Or:
+ In the database, click Tables in the Database column on the left.
+ Select the material in the spreadsheet.
+ Drag the selection into the database and drop it in the Tables
panel now visible in the database.
+ Follow the instructions from the wizard.
Once you have done this, you can move any material around in database
tables if necessary, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org