 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Large Data Import (2548 columns/rows)
I just found the microsoft solution to importing greater than 255 columns into a workbook. This really works great. Unfortunately it only goes to around 510 columns. (http://support.microsoft.com/kb/272729) In my case, I need 2548 columns and 2548 rows. Obviously the rows are not an issue. I need to modify this macro example to continue to run beyond the 510 columns. I'm having a tough time doing that.. although it shouldn't be that hard.. it would seem. My file is a comma delimited text file (CSV) with only numbers in it except for the first column. Don't know if this matters, but the numbers are mostly 0's with a few smatterings of numbers less than 1000. The first row contains the column numbers (1-2548). I was thinking of breaking it at an even 200 columns with 148 columns remaining to be placed on the last sheet (Sheet13). Can someone give me some hints on how to modify this thing to do that?  SignatureTHX cs I can't seem to find the link, but I vaguely remember there is a way you can import more than 512 columns by using the "mod" function to check how many columns have been imported and when to add a new worksheet. Maybe someone else will come along with that link! In the meantime I'll keep checking. HTH, JP > I just found the microsoft solution to importing greater than 255 columns > into a workbook. This really works great. Unfortunately it only goes to [quoted text clipped - 14 lines] > -- > THX cs maybe this is what you were referring to. http://support.microsoft.com/kb/272729/en-us SignatureGary I can't seem to find the link, but I vaguely remember there is a way you can import more than 512 columns by using the "mod" function to check how many columns have been imported and when to add a new worksheet. Maybe someone else will come along with that link! In the meantime I'll keep checking. HTH, JP On Mar 28, 7:00 pm, Cydney <Cyd...@discussions.microsoft.com> wrote: > I just found the microsoft solution to importing greater than 255 columns > into a workbook. This really works great. Unfortunately it only goes to [quoted text clipped - 14 lines] > -- > THX cs Thanks, but that link was in the original post. It was a different one, maybe from PC Magazine or some other website. Still can't find it.... --JP > maybe this is what you were referring to.http://support.microsoft.com/kb/272729/en-us > [quoted text clipped - 3 lines] > > "JP" <jp2...@earthlink.net> wrote in message Actually, that link is correct. You might try a search for "LargeDatabaseImport" which is the name of the function. SignatureTHX cs > Thanks, but that link was in the original post. It was a different > one, maybe from PC Magazine or some other website. Still can't find [quoted text clipped - 9 lines] > > > > "JP" <jp2...@earthlink.net> wrote in message maybe you should consider excel 2007. would probably make this easier. The total number of available columns in Excel Old Limit: 256 (2^8) New Limit: 16k (2^14) SignatureGary >I just found the microsoft solution to importing greater than 255 columns > into a workbook. This really works great. Unfortunately it only goes to [quoted text clipped - 12 lines] > remaining to be placed on the last sheet (Sheet13). Can someone give me some > hints on how to modify this thing to do that? This seems to be the easiest solution. IF I can get IT to give me a 2007 installation. Thanks. Signaturecs > maybe you should consider excel 2007. would probably make this easier. > [quoted text clipped - 18 lines] > > remaining to be placed on the last sheet (Sheet13). Can someone give me some > > hints on how to modify this thing to do that?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.