Page 1 of 1
"File not loaded completely." When Import To Excel
Posted: Fri Mar 12, 2004 12:20 am
by justravis
Trying to import a tab delimited text file into Excel. I go through the text import wizard. Everything looks great there. When I press Finish, I get the error "File not loaded completely." The workbook shows up, but only the first row is imported.
Anybody know what typical mistake results in this error?
Posted: Fri Mar 12, 2004 11:01 am
by John Cartwright
Don't Cross Post please.
Posted: Sat Mar 13, 2004 1:39 pm
by justravis
sorry...didnt intend on people to address this issue on that other thread....i thought new issue..new thread...also, the problems started getting a little too advanced for the Newbie forum.
ANYWAY, I think a solution was found by TheBentinel.com:
It looks like Excel won't import a row with more than 256 columns in it. The column it dies on is PAN1C, which happens to be the 256th column.
I trimmed it down to 250 fields and it loaded fine.
Have a good weekend!
Posted: Sat Mar 13, 2004 7:06 pm
by Straterra
What in the world does this have to do with PHP code?
Posted: Sat Mar 13, 2004 7:15 pm
by justravis
The file was generated by PHP. It was possible that Excel was not accepting the file because I did not format the file right in PHP.