software

We use large CSV files to move data. recently added 3 blanks columns to end
of file for future use. Unless we add dummy char. to these columns Excel will
only upload 16 rows. We prefer not to put dummy char. in columsn only to have
the need to change them later. whats with the 16 row limit?

I don't think there is a limit - if Excel sees that a column is empty
then it won't try to export it. Try putting a single space in Q1, R1
and S1 (or a heading) and see if that cures it.

Peteis there a way to convert a ^ (shift 6 ) delimited.dat file to a csv file?????
is this possible
quot;Petequot; wrote:

gt; I don't think there is a limit - if Excel sees that a column is empty
gt; then it won't try to export it. Try putting a single space in Q1, R1
gt; and S1 (or a heading) and see if that cures it.
gt;
gt; Pete
gt;
gt;

Open it (select delimited, other and use the caret).

Save it as a new name *.csv.
Morefeus Direct wrote:
gt;
gt; is there a way to convert a ^ (shift 6 ) delimited.dat file to a csv file?????
gt; is this possible
gt; quot;Petequot; wrote:
gt;
gt; gt; I don't think there is a limit - if Excel sees that a column is empty
gt; gt; then it won't try to export it. Try putting a single space in Q1, R1
gt; gt; and S1 (or a heading) and see if that cures it.
gt; gt;
gt; gt; Pete
gt; gt;
gt; gt;

--

Dave Peterson

hi dave, on this file you said open it and select delimited now were can i
find this opption , can you be a bit more spacific with your directions with
me i'm new at this.

thanks
MJohnson

quot;Dave Petersonquot; wrote:

gt; Open it (select delimited, other and use the caret).
gt;
gt; Save it as a new name *.csv.
gt;
gt;
gt;
gt; Morefeus Direct wrote:
gt; gt;
gt; gt; is there a way to convert a ^ (shift 6 ) delimited.dat file to a csv file?????
gt; gt; is this possible
gt; gt; quot;Petequot; wrote:
gt; gt;
gt; gt; gt; I don't think there is a limit - if Excel sees that a column is empty
gt; gt; gt; then it won't try to export it. Try putting a single space in Q1, R1
gt; gt; gt; and S1 (or a heading) and see if that cures it.
gt; gt; gt;
gt; gt; gt; Pete
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Open excel
File|open
point at your .dat file.
On the first step of the text import wizard, you'll see two options--delimited
and fixed width.

Choose delimited.

Follow the rest of the wizard to import your file.

Morefeus Direct wrote:
gt;
gt; hi dave, on this file you said open it and select delimited now were can i
gt; find this opption , can you be a bit more spacific with your directions with
gt; me i'm new at this.
gt;
gt; thanks
gt; MJohnson
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Open it (select delimited, other and use the caret).
gt; gt;
gt; gt; Save it as a new name *.csv.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Morefeus Direct wrote:
gt; gt; gt;
gt; gt; gt; is there a way to convert a ^ (shift 6 ) delimited.dat file to a csv file?????
gt; gt; gt; is this possible
gt; gt; gt; quot;Petequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I don't think there is a limit - if Excel sees that a column is empty
gt; gt; gt; gt; then it won't try to export it. Try putting a single space in Q1, R1
gt; gt; gt; gt; and S1 (or a heading) and see if that cures it.
gt; gt; gt; gt;
gt; gt; gt; gt; Pete
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson