[Solved] Import spreadsheet into database

[handiman1010]

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.

[MrProgrammer]

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.

[Mountaineer]

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...