Group,

How do I open a .dat file that is essentially a text file with
about 300 columns (comma delimited) of data. When I attempt to open
the file with Excel, I get only the first 254 columns and the rest is
dropped. I'm willing to put the remaining 60 some columns on another
sheet. How would I do that in VBA. Any help would be great.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=512064

"ajocius" wrote
in message
...

Group,

How do I open a .dat file that is essentially a text file with
about 300 columns (comma delimited) of data. When I attempt to open
the file with Excel, I get only the first 254 columns and the rest
is
dropped. I'm willing to put the remaining 60 some columns on
another
sheet. How would I do that in VBA. Any help would be great.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread:
http://www.excelforum.com/showthread...hreadid=512064


Hi,

Can I suggest that you consider using Access rather than Excel?

300 columns is too big for a single worksheet (as you note) and I
suspect that excel will run like a dog with that much data in it (I am
assuming a significant number of rows / records too?)

HTH,

Alan.

--

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb

Hi Alan,

See MSKB Article # 272729:

'How to import data with more than 256 fields or columns into Excel'
http://support.microsoft.com/?kbid=272729


---
Regards,
Norman



"Alan" wrote in message
...

"ajocius" wrote in
message ...

Group,

How do I open a .dat file that is essentially a text file with
about 300 columns (comma delimited) of data. When I attempt to open
the file with Excel, I get only the first 254 columns and the rest is
dropped. I'm willing to put the remaining 60 some columns on another
sheet. How would I do that in VBA. Any help would be great.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread:
http://www.excelforum.com/showthread...hreadid=512064


Hi,

Can I suggest that you consider using Access rather than Excel?

300 columns is too big for a single worksheet (as you note) and I suspect
that excel will run like a dog with that much data in it (I am assuming a
significant number of rows / records too?)

HTH,

Alan.

--

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb