Copy & Paste from Microsoft Excel

[Former Member]

Dear Experts,

We are using SAP Business One Version 9.2 PL 02 and we have the following question:

When we copy large amount of data from Microsoft Excel (more than 2000 lines), to a Sales Quotation, it takes too long for the process to complete.

We were wondering how the process can speed up . Maybe we should use a specific Excel template?

Thank you in advance

Kind Regards

Vassilis

[Johan_H · Accepted solution]

Hi Vassilis,

With any amount of rows larger than say 50, copy pasting from Excel is just going to be slow. With the amount of rows you are talking about, copy-paste from Excel is not the right solution. You really need to consider the DTW, or some method, like an addon with the DI Server, that uses XML.

Regards,

Johan