On Mon, Aug 20, 2012 at 2:01 PM, Lee Wheeler <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] 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
