I have a csv file sent to me every hour with 220,000 rows and just two colums.
Column A shows a stock code.
Column B shows the number of items of each stock code we have in our warehouse.
For those items we have in stock I need to to put '1 day delivery' in column B. For those items we do not have in stock I need to put '2 day delivery' in column B.
I left a macro to do this and it stalls / collapses because the calc spreadsheet is not designed to handle 220,000 rows.
My question is, how should I best get over this? Should I write a macro to split the sheet into, say 22 parts then do the calculation and then join the sheet together again? Or should I use a database combined with a macro (never really had to use a database before) to do the job. I understand how macros work in calc but don't know how or even if they can be used in base.
Sorry if this question is a little basic for some.
Thanks