VBA - 300 Columns Of Text
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 |
VBA - 300 Columns Of Text
"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 |
VBA - 300 Columns Of Text
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 |
All times are GMT +1. The time now is 10:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com