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?
"File not loaded completely." When Import To Excel
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
-
justravis
- Forum Commoner
- Posts: 53
- Joined: Mon Dec 16, 2002 3:18 am
- Location: San Diego, CA
- Contact:
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!
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!