Re: [libreoffice-users] Calc to Base

Hello Ian

While not and expert, this may work for you.

In the Calc spreadsheet have a heading that matches the field names of 
the database.

If there are more field names than in the spreadsheet, insert blank 
columns beneath them.

Highlight data including heading and copy/paste over named database that 
you are importing to.

After <Next> uncheck blank column fields and continue.

Also I believe you must have a "Primary Key".

Note that there may be better ways, but this has worked for me.


Paul

On 10/6/26 09:47, Ian Bertram wrote:
> I have data in a spreadsheet which I am trying to get into Base. None 
> of the methods coming up in searches are working. Effectively when 
> copying from calc and attempting to paste into a predefined table or 
> to create a new table, paste is greyed out. There must be a better way 
> than laboriously retyping everything. Assistance please.
>
>
> Version: 26.8.0.3 (X86_64)
> Build ID: bce0998afefdbc355585ca324285661a2170ba77
> CPU threads: 12; OS: Windows 11 X86_64 (build 26200); UI render: 
> Skia/Raster; VCL: win
> Locale: en-GB (en_GB); UI: en-GB
> Calc: threaded
>
>
> Ian Bertram
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy