I’m trying to do something very simple, but having a heckuva time and getting nowhere with the Help system. I have several (three-column, nothing exotic) Excel sheets that I want to import into one table in Base in order to create a couple of reports. I have tried Cut and Paste per the Help system, but everything winds up in one cell in the table. Yup, one cell.
Can anyone help? I have to think this is a very straight-forward thing to do. Thanks much.
Hello,
Instead of directly using Excel, open as or copy to Calc and save as .ods file. Insure columns have labels (used for field names).
Then copy and paste. Have done this many times and the only problem (aside from incorrect input data) which I recall having is an incorrect field type potentially assigned. So double check the field types when processing this. Also make certain to set your primary key.
Thanks for your prompt reply.
I tried saving it as an .ODS file and cutting/pasting, but it just put part of one record in one cell in the table. The field types match and I have a primary key. I’m thinking either something is corrupted in my install or I’m missing one tiny simple little step somewhere.
Can you post a sample - edit your question and use paperclip icon in upper left toolbar. Excel or ods or both. No personal/confidential info please.