+Web-ling Posted August 5, 2002 Share Posted August 5, 2002 Is there any way to export the results of a pocket query to a text file that could be imported into another program, like an Access database? Link to comment
+Olar Posted August 5, 2002 Share Posted August 5, 2002 Web-ling does an Excel worksheet do anything like you want? Geobuddy will open the pocket query and you can save it as a comma-separated value file for Microsoft Excel. Olar Link to comment
+Markwell Posted August 6, 2002 Share Posted August 6, 2002 If Geobuddy can export the file to comma-delimited, you can import it into Access. Markwell Chicago Geocaching Link to comment
+Web-ling Posted August 6, 2002 Author Share Posted August 6, 2002 Thanks! That's exactly what I'm looking for. Link to comment
+Web-ling Posted August 6, 2002 Author Share Posted August 6, 2002 Thanks! That's exactly what I'm looking for. Link to comment
dboggny Posted August 6, 2002 Share Posted August 6, 2002 hey did you get that to work. i tried but my lack of computer savy is limiting me. SR and dboggny. Oh man, my mother in law is here Link to comment
+Web-ling Posted August 6, 2002 Author Share Posted August 6, 2002 quote:Originally posted by dboggny:hey did you get that to work. i tried but my lack of computer savy is limiting me. SR and dboggny. Oh man, my mother in law is herehttp://img.Groundspeak.com/user/9372_700.gif I opened the .loc file with geobuddy, then exported it as a quoted comma-separated .csv file. I tried to pull the .csv file directly into Access, but got some errors, so I pulled it into Excel first, then imported it into Access from there. Kind of a round-about process, but it got me the data I wanted. I'll probably write some macros later to automate the process. Link to comment
Recommended Posts