Hi, Please go through this link for clarification
http://programmshelp-net.blogspot.in/2012/04/read-xls-file.html Sreekanth.C On Tue, Aug 21, 2012 at 4:57 PM, Stephen Russell <srussell...@gmail.com>wrote: > On Mon, Aug 20, 2012 at 2:01 PM, Lee Wheeler <icestor...@hotmail.com> > wrote: > > Thanks for the tips. I think I may have found out my problem. I have > two > > programs. The first is a download program which pulls records into a > > spreadsheet. The second can uploads those records into another database. > > When the first program runs, it creates a named range(which I didn't > know) > > called LASPBS which goes from the first record to the last record. When > I > > pull up the data it is in a tabbed sheet at the bottom called LASPBS as > > well..... > > > > In program 2, I do a select * from LASPBS(expecting it to pull from the > > sheet). Turns out, it hits the named range first. No problem until you > add > > records to the spreadsheet. The named range still stays the same as it > was > > when the first time it was created. Say the first time it ran the > > spreadsheet had 100 records in it, the range would be from 1-100. If you > > manually add in another 50 records and rerun it, the select statement > pulls > > from the range LASPBS which is still stated as 1-100 and ignores the new > 50. > > Two ways around it, name the sheet something different than the range or > > change the select statement to... select * from [LASPBS$] which will grab > > the sheet and not the named range. > > > > Easy fix but what a total beast to try and step through and resolve. > -------------------- > > The dreaded Range strikes again! > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to dotnetdevelopment@googlegroups.com > To unsubscribe from this group, send email to > dotnetdevelopment+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
