Apache OpenOffice Community Forum

Hi! How do I import the information in a spreadsheet into a new database. I know I have done this before but it has been a few years and I can't seem to figure it out. When I create a new database I thought I could copy and paste the spreadsheet data into the database but when I try to do that it pastes all the date into one cell. Any help will be much appreciated.

handiman1010 wrote: ↑Thu Dec 07, 2023 4:54 am How do I import the information in a spreadsheet into a new database.

Hi, and welcome to the forum. Please search first before posting.
Search of Base forum found 421 matches: import spreadsheet

Took me about 30 seconds to find this, less time than it took you to register at the forum and create a topic. I am done helping here.
How do I import an OO spreadsheet into an OO DB?

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

Select and copy a spreadsheet (ctrl+A, ctrl+C)

Switch to Base, don't open the table, but select paste from the context menu (right muse button) of the destination table.

Follow the assistant to map/select columns...