Importing more than 65359 rows of data

I know there is a way to make excel accept more data. I have done it o
other computers but have forgotten the command.  Can someone pleas
remind me how.

Thanks,

Jef

--
Message posted from http://www.ExcelForum.com

0
5/1/2004 3:51:09 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
236 Views

Similar Articles

[PageSpeed] 44

Use multiple worksheets????



"jgorski <" wrote:
> 
> I know there is a way to make excel accept more data. I have done it on
> other computers but have forgotten the command.  Can someone please
> remind me how.
> 
> Thanks,
> 
> Jeff
> 
> ---
> Message posted from http://www.ExcelForum.com/

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
5/1/2004 5:23:51 PM
Hi Igorski,

With XL97 onwards the number of rows in a worksheet is limited to 65536
rather than 65539.

Microsoft Knowledge Base Article  120596 ("Importing Text Files Larger Than
16384 Rows"):
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
 provides a  routine to  import  data to multiple worksheets.

As indicated in the KB article, you should replace 16384 with 65536 in the
routine - 16384 being the maximum number of rows in an earlier version of
XL.

---
Regards,
Norman

"jgorski >" <<jgorski.15l3r7@excelforum-nospam.com> wrote in message
news:jgorski.15l3r7@excelforum-nospam.com...
> I know there is a way to make excel accept more data. I have done it on
> other computers but have forgotten the command.  Can someone please
> remind me how.
>
> Thanks,
>
> Jeff
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
normanjones (1047)
5/1/2004 5:35:46 PM
Hi Jeff,

When opening a file and the Text Import Wizard appears, 
you can enter a value in the 'Start import at row' box. 
The maximum in Excel 2002 is 32767. Excel will then skip 
that number of records in the import file. Your sheet will 
contain records 32767 to 98302.

Is that any help?

Paul


>-----Original Message-----
>I know there is a way to make excel accept more data. I 
have done it on
>other computers but have forgotten the command.  Can 
someone please
>remind me how.
>
>Thanks,
>
>Jeff
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
anonymous (74721)
5/3/2004 10:52:14 AM
One more option.

Just use your favorite editor to split your text file into smaller pieces.

Then open each separately.

"jgorski <" wrote:
> 
> I know there is a way to make excel accept more data. I have done it on
> other computers but have forgotten the command.  Can someone please
> remind me how.
> 
> Thanks,
> 
> Jeff
> 
> ---
> Message posted from http://www.ExcelForum.com/

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
5/3/2004 10:49:25 PM
Reply:

Similar Artilces:

Can I convert columns to rows?
I need to convert address information, which is on word and listed vertically, to an excel spreadsheet, and have the information list out horizontally. Is this possible to do? I am familiar with the basics of each program, but using "range,formula,value" options in excel confuses me. Here's an example: (My data in word) Mel's Tire Store, Inc. 300 Culbertson Avenue Worland, WY 82401 (307) 347-3601 Need to copy and paste so data spreads horizontally in Excel, under these colum headings: "Business Name" "Address" "City&qu...

Multi CSV file import #2
I have about 200 csv files that I would like to import into excel. After figuring out that I can only import 1 file at a time, I am tryin to seek a solution to this time consuming problem. Is there an easy wa to import them all at one time, (all the same layout). Is there a way t merge them all and import them, or any other solution? Jef -- Message posted from http://www.ExcelForum.com ...

Is there any way I can import a report design from excel?
Hi My client has designed his Delivery Notes in excel. Is there any way I can import this into access as a report design? Stapes No. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Stapes" <steve.staple@gmail.com> wrote in message news:64a0bb8a-98f5-4cb8-b436-c0cff3ff65c4@s8g2000prg.googlegroups.com... > Hi > > My client has designed his Delivery Notes in excel. Is there any way I > can import this into access as a report design? > > Stapes ...

Inserting a Word doc does not preserve the imported files' layout.
Hi all! I have two Word documents. They both use the same template (.dot). Document 1 is built by managed code in vb. Document 2 is a document manually built - one page only, and has the following "structure": 1. (Topmost) A text box with black fill and white text. 2. (Beneath 1) Two collumns. Left has text only, right has a picture and some text boxes placed on the picture. 3. (Beneath 2) One collumn. Text only. 4. (Beneath 3) A logo 5. (Beneath 4) A text box with black fill and white text. When calling insert file either doing it manually in Word 2002 SP3 (I...

Power point crossed with data
I'm designing a data base that has a power point look to the presentation of reports like a slide show updated with forms any help would be nice ...

data sort is not including all columns in sort
I have a list with name, company, address, city.....etc. When I click on data sort (i do check the box to include column headings) and do a sort by say address, it will sometimes exclude a column such as name from the sort. It does not always do this. Is this a glitch? Do I need to highlight the entire list before I sort? Also, sometimes if I just use the Ascending or Descending icon rather that going to data, sort it will only sort that column and not the rest of the data with it. Those are the reasons that I don't trust excel to guess at the range I want sorted. I'll...

can i wrap rows to form multiple rows per row to fit on 1 sheet?
i have a worksheet with very long rows (a to cf). For printing i would like to wrap the rows to fit on a single page, and then seperate each set with a space. I would also like to wrap the headers too, of course. is this possible? Say you're creating 10 columns per new row. So it kind of looks like this: $A$1 $B$1 $C$1 $D$1 $E$1 $F$1 $G$1 $H$1 $I$1 $J$1 $K$1 $L$1 $M$1 $N$1 $O$1 $P$1 $Q$1 $R$1 $S$1 $T$1 $U$1 $V$1 $W$1 $X$1 $Y$1 $Z$1 $AA$1 $AB$1 $AC$1 $AD$1 $AE$1 $AF$1 $AG$1 $AH$1 $AI$1 $AJ$1 $AK$1 $AL$1 $AM$1 $AN$1 $AO$1 $AP$1 $AQ$1 $AR$1 $AS$1 $AT$1 $AU$1 $AV$1 $AW$1 $AX$1 $AY$1 $...

Word 2007 how to get data from forms to Excel
I have forms that have been filled out by various people and would like to export the data into an Excel worksheet. This seemed straightforward in Word 2003, but I cannot get it to work in Word 2007. The actual form is a Word 2003 document. When I save the file as a txt file (after Word options / Advanced / Preserve fidelity / check "save form data as delimited text file") it creates the delimited file, but it gets overwritten when I close the original filled form. Any ideas? Thanks. I am having a similar problem, but the "save form data as delimited text...

Change source according to data entered in a template.
I am using third party software to enter data into a template. Things seem to work fine, except I want to vary the source data for the chart in the template according to how many rows of data have been entered from the third party. Is there a way to do this?? try using a defined name for the source data edit>name>define>mysourcerange>refers to =offset($a$2,0,0,counta($A:$A),6) -- Don Guillett SalesAid Software dguillett1@austin.rr.com "ANStech" <ANStech@discussions.microsoft.com> wrote in message news:823D805C-863C-4F5A-BFB2-434A7260989C@microsoft.com... &...

Loosing Data-Help needed
Hi All, I have an huge spreadsheet with macros on it, which is continuously updated. Off recently my spreadsheet is loosing the data i.e. I will have 2-3 days old information, all the updates that we made recently is lost. I am saving the spreadsheet every 15-20 mins still it is doing it. Could anyone please help me :confused: . Thank You, Naveen -- neomemphis ------------------------------------------------------------------------ neomemphis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33240 View this thread: http://www.excelforum.com/showthread.php?th...

Reference architecture for mobile data acquisition?
Hello, not sure if this is an appropriate group for this question, but SQL server is part of that ... Basically I'm looking for some kind of reference architecture for a project which is basically about mobile data acquisition. On an embedded device running WinCE and SQL Compact Edition 3.5, measurement data is received by external devices (e.g. via CAN bus), locally stored in the compact edition database and then transmitted via GSM, satellite ... to a central database server running SQL Server 2005 Standard. Using Microsoft technologies (WinCE, SQL Compact Edition, S...

getting all data about search subject
I have a client that had CRM installed on a server and migrated their ACT database over to it(i came into this on the tail end so i didn't set it up)--whenever they do an account lookup they want to get all the info surrounding that client--emails, images , past correspondances, invoices, quotes etc... they want all this in one click so to speak---in reading these posts two things popped out at me "searchpac 360" and"only the user can bring up what they own or produced" since this firm has several employees on the system all saving and sending info to and abou...

How backup data in Outlook2003w/BCM?
I'm using Outlook 2003w/BCM, and wondered how to backup everything before I uninstall/reinstall Outlook, so I get back to everything looking exactly the way it was before the re-install. (What cause this is...I have an underlying WinXP problem affecting the whole PC, so I have to format/reinstallWinXP, and of course that causes me to loose and have to re-install Outlook...but right now Outlook works ok, so the data's still in tact) In Outlook, there's a File > Business Database > Backup... but it says I also need to backup "linked items." So, what all needs to be...

Pull data from multi-row records
I've got about 50 records that were imported. Each record has about 30 rows. A portion of one would look something like: 082 04$a813/.54$222 049 \\$aLVGA 100 1\$aKelton, Elmer. 245 10$aRanger's trail$h[electronic resource] /$cElmer Kelton. 260 \\$aPrince Frederick, Md. :$bRecorded Books ;$a[Boulder, Colo. :$bMade available electronically by] NetLibrary,$c2005. 300 \\$a1 sound file (9 hr.) :$bdigital, wma file. 440 \0$aLone Star audio 490 1\$aTexas Rangers series ;$v4 538 \\$aSystem requirements: Windows Media Player compatible, check NetLibrary we...

Macro to add name on a cell based on the data
Hello, I am using Excel 2003 and I need help to do a macro. I copy and paste data into a worksheet call "Table" In the worksheet I want to put a specialist name in the column called "Specialist" beside a column called "STATE" the specialist name will be based on what the state is. For example If the state contains "CA" I want the specialist name to be "Anna" or the state of "OR" I again want the specialist name to be "Anna" Now if we get a different state "UT" I want the specialist name to be "...

Select a certain number of cells in a row
Hi, I'd like to have the macro to select row 5 to 10 in the active column. May I know what is the VB code to write? Regards, Valerie maybe... dim myRng as range dim myCol as long with activesheet mycol = activecell.Column set myrng = .range(.cells(5,mycol),.cells(10,mycol)) end with myrng.select ======= or with activesheet .cells(5,activecell.column).resize(6).select end with I'm not quite sure why you want to select that range. But for the most part, if you act directly on the range (and avoid .selects), you're code will work faster and be easier to modify. Dolph...

how to protect appointed rows or columns to use the mouse and keyboard
hzh, You could include some text in your post. Maybe then we could figure out what you mean by "appointed"?? "To use the mouse and keyboard" makes absolutely no sense whatsoever. Maybe you're a new poster??? If so, take a look here before reposting: http://www.cpearson.com/excel/newposte.htm Most anything that could be asked in the newsgroups has already been answered. Take a look here and you may just find what you're looking for (whatever that is)?? http://tinyurl.com/29pby John "hzh" <hzh62@163.com> wrote in message news:7A2382EE-00E6-4679...

want to limit worksheet to 1000 rows instead of 65,000
My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows. I have 1 GB or ram and 6 worksheets causes problems. How can I set a default to limit the max number of rows and columns. Thank you All (pre-XL07) worksheets have 65536 rows. That can't be changed. However, unused rows don't take up any memory or disk space, so there's no need to try to limit them. What problems are you having? In article <1C30E096-94AD-4244-A976-FEE04B45912D@microsoft.com>, GeoObject <GeoObject@discussions.microsoft.com> wrote: > My worksheets only need 1000 rows b...

Why can't I enter any data on any new worksheets?
I cannot enter any information on any new, or existing worksheets. I've even tried uninstalling and reinstalling the program. Please help! ...

Feeding MS Excell with MS Word data
Hi there! I need to know if it is possible to pass data from MS Word to MS Excell The data in MS Word is text, and I need to place some information in specific columns in an Excell Workbook Thanks Christian ...

Data Import w/ Multiple types of delimiters
I'm working on a database that will import files that contain multiple types of delimiters (~, * & ^). Each of the different types of delimiters indicate the start of a different section. How do I specify that there is more than one type of delimiter? Everything I see only allows one type. Does this have to be done through VB? Thanks! Yes, it would have to be done through VBA (Visual Basic for Applications, which is what Access uses, not VB) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John W" <jw2554@yahoo.com> wro...

Data Transfer Issues with remote site
Dear Developers, I am hoping one of you may have some suggestions on what may be causing this issue and provide some suggestions on how to reduce the occurrence of this issue. We have a .NET 1.1 Windows application that ties in with Great Plains running SQL Server 2000, using ADO .NET 1.1. The application is run on three sites – one local (main server) and two remote. I will call them Remote1 and Remote2 for the sake of this posting. In overview, the application provides services for filling orders. Orders are retrieved form the main server and order lines are posted for ver...

Importing a distribution list into another distribution list
I am using Microsoft 2002 and wonder if I can import an existing distribution list into another existing distribution list? I am trying to avoid entering individual emails into an existing distribution list. I'd like to be able to import the entire list. Pat Speir <anonymous@discussions.microsoft.com> wrote: > I am using Microsoft 2002 and wonder if I can import an > existing distribution list into another existing > distribution list? I am trying to avoid entering > individual emails into an existing distribution list. > I'd like to be able to import the ...

Lost link to old outlook data after PC crash
Any help would be appreciated. My husband fried our configuration, and ended up having to re-install every programme. In the process...I can no longer access my old Outlook express emails (local folder)...how do I get them back? Thanks in advance ...

Importing MFC resources
Hi, I have a very large project that consists of several MFC applications, all created with VS 7.1. What I'd like to do now is create MFC resources that can be shared among these different applications. For example, I'd like to create a dialog resource, along with the code to handle that dialog's controls, and then bundle it up for use by all the other applications. I've tried a few things with very little success. I seem to always end up with resource ID conflicts when I import a resource into another project. I can manually patch this up in the resource.h file, b...