| View previous topic :: View next topic |
| Author |
Message |
David Smith Newbie

Joined: 30 Jul 2012 Posts: 2
|
Posted: Mon Jul 30, 2012 3:11 am Post subject: Importing large spreadsheet files into Base |
|
|
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 |
|
| Back to top |
|
 |
mgroenescheij Super User

Joined: 20 Apr 2011 Posts: 862 Location: Australia
|
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). |
|
| Back to top |
|
 |
David Smith Newbie

Joined: 30 Jul 2012 Posts: 2
|
Posted: Wed Aug 01, 2012 11:40 pm Post subject: Post subject: Importing large spreadsheet files into Base |
|
|
| Thanks. Should have realised. Havent tried it yet but please treat this as solved. |
|
| Back to top |
|
 |
|