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