Data Extraction for 64-bit (Not 65,536 rows xls excel file)

Data Extraction for 64-bit (Not 65,536 rows xls excel file)

emreakyazicigsl
Advocate Advocate
605 Views
3 Replies
Message 1 of 4

Data Extraction for 64-bit (Not 65,536 rows xls excel file)

emreakyazicigsl
Advocate
Advocate

Hello everyone,

 

I have AutoCAD 2021 and Office 365, my PC is obviously 64-bit and when I apply Data Extraction, I can only convert to xls file with 65,536 rows, whereas, generally my files includes more than 65k rows. At least, I need to convert these files 64-bit Excel with 1,048,576 rows. When I tried to convert .csv file, columns are united in one column and my data turned to garbage.

 

What can I do? Is it possible? If not, what do you suggest?

 

I believe that in 2021, I should not only extract to 32-bit excel (xls file) with 65k rows. Please help me. Thank you.

0 Likes
Accepted solutions (1)
606 Views
3 Replies
Replies (3)
Message 2 of 4

pendean
Community Legend
Community Legend
Accepted solution
"The maximum number of columns that can be exported to an XLS and MDB file is 255."
https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2021/ENU/AutoC...

>>>...What can I do? ...<<<
You will need multiple XLS files, not just one.
0 Likes
Message 3 of 4

emreakyazicigsl
Advocate
Advocate

So, rows are limited with 65k too? No way to increase them?

0 Likes
Message 4 of 4

pendean
Community Legend
Community Legend
If you could that would have been the answer.
0 Likes