How many rows can VB import (VB6 + VB Net)

[steveh]

Morning all

We have a bespoke software package that is written in VB6 which will eventually be migrated to VB.NET (2012). If I am running a 13 month report Excel fails to import all of the data, the programmer says that this is because of a limitation in all versions of VB, this is what he says

"Excel has a limit of 32756 rows when being fed from a 3 party routine such as VB (even with .Net, I've just checked !) so next best option would be to run 2 run 2 reports and manually concatenate them."

We are just a SME how do the big boys with lots of data get around this or is he in error with his findings above?

[HansV]

We'd have to know:
- What is the format of the data you want to import? (A text file, an Access database, ...)
- What method does the programmer use to import the data into Excel?
- Are you using .xls or .xlsx format?

[steveh]

We'd have to know:
- What is the format of the data you want to import? (A text file, an Access database, ...)
- What method does the programmer use to import the data into Excel?
- Are you using .xls or .xlsx format?

Hi Hans

thanks for the reponse, he has however just called me to say that he had made a mistake and the limitation was the 65536 rows in Excel 97-2003 and that he had coded something incorrectly

[HansV]

OK, thanks for the update.