Search results

Sorry, I wasn't able to tell exactly what the name of that program was, or if it was just an Access database. Could you please clarify and let me know where I might find it to try it out?

Thanks for the suggestions. I guess I was being too optimistic thinking it'd be a breeze to whip up something in Access. I probably shouldn't try to do too much thinking when I haven't had enough sleep. :eek: Thanks to Bob, too. I'll give that program a try, even though I hadn't wanted to...

Recently I've been using QuickBooks, but I'm not very satisfied with it. For one thing, it's got alot more features than what I'll probably ever be using. But, the main reason I don't really care for it is that there are things that it doesn't seem to be able to do "automatically", and with...

Well, I got everything extracted (with your much-needed help). The only thing is, the data in the main GeoNames table is not as accurate as they might like to think it is. I get erroneous results because of their loose definition of cities. Turns out, the county I live in has about 90...

Thank you so much, Bob. You've been a great help. I guess this was a bit more involved than my very limited knowledge of Access could handle. I hope I can manage from here.

Here you go. Hope this helps.

Well, I'm having a heck of a time getting the county code field stripped down. The field from the original file contains entries for all counties in all countries. It's not a field that is consistently in the form of xx.xx.xxx like I had originally thought. The form is: country, before the...

Well, the reason I was thinking of creating a new table (without all of the extra info that the other two tables have) is because I wanted to use that new table for other purposes as well, one of which is for importing to a MySQL database. I just think it'd be easier for me (personally) to work...

I've got some tables I pulled off GeoNames.org that I need to extract data from. One table has everything I need except the counties listed in it. Instead of that, it gives a county code. The other table has the actual county names associated with those codes. In the main table, country and...