Error message "File not loaded completely"

[Bravon]

Hi, I've got a VB application that calls Crystal, links
with SQL Server and outputs a CSV file. In our test
environment, where we have limited test data, the CSV file
created opens fine with Excel 2000. In our production
environment the CSV file opens but an error pop up appears
in Excel saying "File not loaded completely". On clicking
<OK> the file appears to load up but the formatting of the
first few lines in the report is all wrong - the first 9
rows of data appear in a single row. This means in the
first row we have a cell populated in the 221st column
when, generally speaking, it should be in row 58. The
number of rows in the CSV file is 2343 and its file size
is 1203KB. Searching the net for the error message we got
it says that there is a limit in Excel of 65,536 rows.
Now, our CSV file is no where near that size and yet we
see this error message. Has anyone got any ideas what the
problem is? How to fix it? A workaround? Or point me in
the right direction of what I should look at?

Many thanks in advance!
Bravon

 

[DNF Karran]

That txtfile sounds way too big for the data you are importing. Open i
with a text editor and see if it has lots of blank rows at the botto
(round 60,000+) as these blank rows will trip the error.

Dunca

 

[Dave Peterson]

It can also be too large for the 256 columns that excel has.

I'm not sure if this applies to Crystal, but when I transfer text files from
Unix to the pc, I usually have to make sure that each line ends with a Carriage
Return/Line Feed combination (hex 0D 0A).

The Unix files end with only the 0A.

Can you look at the file with a text editor that shows hex codes?

When I convert these stuff, I use a freeware/shareware program called Unix2DOS.
You could find a bunch by searching http://www.shareware.com (or even google).

 

[onedaywhen]

Using ADO and the OLE DB provider for MS Jet you can use SQL to create
the workbook/worksheets you require i.e. go direct to the SQL Server
data and get the OLE DB provider to create the workbook for you. Why
use Crystal and a CSV file?