Originally posted by: ShaCplex

Dear sir,

I am currently modelling in OPL studio and I am feeding the data using excel sheet. As we know that excel has a limitation of about 10 lakh rows. So if I want to use a bigger dataset, can you suggest me the best alternative? Can I make use of csv or text files? or can I split the data in multiple excels?

Also, if yes how can I read data from csv or excel files?

I have another query that how to read data from database in the version12.7.1?

Please help me.

Regards,

shahul

Hi,

in

https://www.linkedin.com/pulse/how-opl-alex-fleischer

you have 2 links how to export and import from csv

But you may also split your big SheetRead in many smaller ones as I suggested you in the past

About Databases and 12.7.1 have you looked at https://twitter.com/AlexFleischer1/status/878121454428012544

?

regards

Originally posted by: ShaCplex

Thank you sir!