Importing large spreadsheet files into Base

David Smith · Newbie Joined: 30 Jul 2012 Posts: 2

Hi
I wished to import a spreadsheet which was 6.8MB in csv format, or about 1.3MB in ods format into Base. I started by copying the whole sheet and trying to paste it. After 5 minutes the process had not finished and I did Cntrl alt del to recover. The intended recipient table was empty.

I then tried copying and pasting in about 25% of the data - same thing happened. I have started importing in much smaller chunks - which works fine. I dont like doing this because you have to check carefully that no records are duplicated or omitted.

Is there a better way?

thanks
David

mgroenescheij · Posted: Wed Aug 01, 2012 8:29 pm Post subject:

Hi,

Have you tried to adjust your memory settings in Tools --> Options --> OpenOffice.org ... Memory

Otherwise with the CSV editor http://csved.sjfrancke.nl/ it is possible to split large CSV files.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

David Smith · Newbie Joined: 30 Jul 2012 Posts: 2

Thanks. Should have realised. Havent tried it yet but please treat this as solved.