Tim, You could always register the Excel file first without a range and then determine the number of rows in the associated Table and then re-register the Excel file again this time setting the range since you have determined the number of rows that are going to be imported. (-1 for the column heading of course!)
or another way 'off the top of my head' would be to register the Excel file without a range, save as a native MI table. and then update the table columns titles with the entries in the first row and then delete the first row. Best Regards and a Happy New Year, Dave David P. Langley Director of Programming Services Mapping Solutions, LLC 4660 S. Hagadorn Rd. Suite 120 East Lansing, MI 48823 USA Voice: (+1) 517-332-7735 Cell: (+1) 517-719-6359 Fax: (+1) 517-332-1329 Email: [EMAIL PROTECTED] SMS: 5177196359 (@page.nextel.com) www.mappingsolutions.com - Need street level data for North America or Europe. Check out Map-In-A-Box!!! >Is there a way of determining how many rows exist in an Excel file when importing it into MapInfo? > > >I have a VB program using MapInfo Integrated Mapping and I want to import an Excel file. The problem is that while I know how many columns >there are, I do not know how many rows there are. The Range portion of the Register table statement requires the number of rows. I cannot >drop the Range portion because the first row is used for the column titles. >Thanks, >Tim Fast >Pioneer Hi-Bred International, Inc. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9722
