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

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

emreakyazici — Mon, 07 Jun 2021 10:26:24 GMT

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.

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

pendean — Mon, 07 Jun 2021 14:29:10 GMT

"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/AutoCAD-Core/files/GUID-D1433C93-0E7F-46D0-8D05-78DF3626B146-htm.html

>>>...What can I do? ...<<<
You will need multiple XLS files, not just one.

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

emreakyazici — Wed, 09 Jun 2021 15:12:16 GMT

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

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

pendean — Wed, 09 Jun 2021 19:36:06 GMT

If you could that would have been the answer.