Importing into a database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Importing into a database

John Buono
Hi, I have a problem.  I am trying to import a CSV file into a database.  I have followed help page but it does not work.

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.  What am I doing incorrectly?

John
Reply | Threaded
Open this post in threaded view
|

Re: Importing into a database

Martin Groenescheij


On 05/12/17 2:48 AM, John Buono wrote:
> Hi, I have a problem.  I am trying to import a CSV file into a database.  I have followed help page but it does not work.
>
> 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.  What am I doing incorrectly?

What you do incorrectly is hard to say, but you could start to copy the
data into a new table and see if that works.
 From there you could check column names and attributes and check if
there are any differences.
Don't forget that spreadsheets are more forgiving on data
inconsistencies than databases.
Without more insight into the data structure there is not much more I
can say.

>
> John
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Importing into a database

Brian Barker
In reply to this post by John Buono
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: [hidden email]
For additional commands, e-mail: [hidden email]