You could then either work with the file in Access, or export portions of the file to use in Excel.įinally, you could use a macro to import the records in the large source file. Unlike Excel, Access has virtually no limit on the number of rows you can import. If you don't want to break up your input files, you might consider importing the file into Access. Thus, you can import the first file (now 55,000 rows) into one worksheet and the second file (also 55,000 rows) into the second. Delete the second half of the first text file and the first half of the second. For instance, if you have a total of 110,000 rows you need to import into Excel, and you are operating under the 65,535-row limit, you could make two copies of the raw text file. One possibility is to make copies of the raw text file (the one you want to import) and then cut the size of each file down. (Those later versions broke the 65,535 row limit.) There are a couple of things you can do, however. If you need to import that file into Excel, then doing so can appear almost impossible without upgrading to Excel 2007 or a later version. It is very possible, however, to have a raw data file that has more than this number of rows. Excel has a limit on the number of rows you can have in a worksheet-up to 65,535.
0 Comments
Leave a Reply. |