Import a Microsoft XLS spreadsheet into Base

Walter 2468 · Post by **Walter 2468** » Thu Oct 22, 2009 3:18 pm

I have a Microsoft XLS spreadsheet that has two columns of data. How can I import that data? I already have a table in Base that has two columns with the same name as the two columns in the XLS spreadsheet.

eremmel · Post by **eremmel** » Sun Oct 25, 2009 4:43 pm

Have a look to import calc sheet into base. You might need a conversion step from excel sheet to calc sheet.

edit this topic's initial post · Post by **Villeroy** » Sun Oct 25, 2009 5:10 pm

eremmel wrote:Have a look to import calc sheet into base. You might need a conversion step from excel sheet to calc sheet.

Spreadsheet cells are all the same once they are loaded into Calc. They have numbers, text, errors or nothing in them. IMHO it is best practice to import cells into well prepared database tables with restrictive types, rules and indices since spreadsheet data are unreliable.

Import a Microsoft XLS spreadsheet into Base

Import a Microsoft XLS spreadsheet into Base

Re: Import a Microsoft XLS spreadsheet into Base

Re: Import a Microsoft XLS spreadsheet into Base