Not all spreadsheet info imports into base

Discuss the database features

Not all spreadsheet info imports into base

Postby waynec444 » Fri Jan 15, 2021 6:26 pm

I have twice tried to transfer OO Calc spreadsheet info into Base but it only imports some of it, a different number each time. How do I get it all to transfer?

I have followed the instructions given.
Open Office 4.1.10 on Windows Vista
waynec444
 
Posts: 82
Joined: Wed Jan 21, 2015 6:09 am

Re: Not all spreadsheet info imports into base

Postby RoryOF » Fri Jan 15, 2021 6:35 pm

Which instructions? Which database engine? We are not mind-readers.

An uploaded copy of your file would be helpful.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32535
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Not all spreadsheet info imports into base

Postby waynec444 » Fri Jan 15, 2021 6:38 pm

importing from Calc to Base, all OO.
Open Office 4.1.10 on Windows Vista
waynec444
 
Posts: 82
Joined: Wed Jan 21, 2015 6:09 am

Re: Not all spreadsheet info imports into base

Postby Villeroy » Fri Jan 15, 2021 7:59 pm

Works for me.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29710
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Not all spreadsheet info imports into base

Postby UnklDonald418 » Fri Jan 15, 2021 9:54 pm

Database columns are strongly typed, but speadsheet cells are not.
For instance when importing a column into a database table with one of the numeric types, all the cells in the spread sheet row must either contain numbers or be empty. If some of the cells in the spreadsheet column have string data, such as "Unk" or "-", those rows will not be imported and an error will be reported by the Copy Table dialog.
Another source of problems is if some spreadsheet cells contains a string that is longer than the length specified on the Type Formatting page of the Copy Table dialog for that column.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1396
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Not all spreadsheet info imports into base

Postby Villeroy » Fri Jan 15, 2021 10:01 pm

There are so many possible problems when pasting spreadshit into strictly typed data structures that it deserves yet another tutorial that nobody reads. Spreadsheet users do not even understand the differences between formulas and values, formatting and data, text and number.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29710
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests