Not all spreadsheet info imports into base

Discuss the database features
Post Reply
waynec444
Posts: 84
Joined: Wed Jan 21, 2015 6:09 am

Not all spreadsheet info imports into base

Post by waynec444 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Not all spreadsheet info imports into base

Post by RoryOF »

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

An uploaded copy of your file would be helpful.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
waynec444
Posts: 84
Joined: Wed Jan 21, 2015 6:09 am

Re: Not all spreadsheet info imports into base

Post by waynec444 »

importing from Calc to Base, all OO.
Open Office 4.1.10 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Not all spreadsheet info imports into base

Post by Villeroy »

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
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Not all spreadsheet info imports into base

Post by UnklDonald418 »

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.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Not all spreadsheet info imports into base

Post by Villeroy »

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
Post Reply