M madlin Jan 12, 2010 #1 My data exceeds the number of lines in excel. Is there a way to import all of the data into multiple worksheets?
My data exceeds the number of lines in excel. Is there a way to import all of the data into multiple worksheets?
S Sheeloo Jan 12, 2010 #2 In Excel 2003? Not really... You can either break your files into smaller pieces or write code to import it into multiple sheets. Excel 2007 allows 1,048,576 rows. See http://office.microsoft.com/en-us/excel/HP100738491033.aspx
In Excel 2003? Not really... You can either break your files into smaller pieces or write code to import it into multiple sheets. Excel 2007 allows 1,048,576 rows. See http://office.microsoft.com/en-us/excel/HP100738491033.aspx
G Gord Dibben Jan 12, 2010 #3 Run a macro to split as you import. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596 Gord Dibben MS Excel MVP
Run a macro to split as you import. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596 Gord Dibben MS Excel MVP
