ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Importing File greater than 65536 (https://www.excelbanter.com/excel-worksheet-functions/104736-importing-file-greater-than-65536-a.html)

dan

Importing File greater than 65536
 
I need to import a file greater than 65536 lines. I have read and tried
Microsofts macro on this (http://support.microsoft.com/kb/120596/en-us) but I
need the file to be in a Fixed Width format and not the Delimited format the
above macro provided.

How do I switch the import over to Fixed Width?

Thanks

Dave Peterson

Importing File greater than 65536
 
You have a suggestion at your other post.

Dan wrote:

I need to import a file greater than 65536 lines. I have read and tried
Microsofts macro on this (http://support.microsoft.com/kb/120596/en-us) but I
need the file to be in a Fixed Width format and not the Delimited format the
above macro provided.

How do I switch the import over to Fixed Width?

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com