< Browse > Home / Archive: June 2009

| Mobile | RSS

Converting KML to SHP or SHP to KML

You can use many different free tools (such as Zonum Solutions or ArcScripts) to convert from Keyhole Markup Language (KML) to ESRI Shapefile (SHP) and vice-versa.
The best advice I can give you is keeping on thing in mind: Google Earth only reads and writes KML/KMZ using the WGS 1984 coordinate system. That means that:

If you [...]

[ More ] June 14th, 2009 | 2 Comments | Posted in tech |

SQL Server vs Access

How to import data from SQL Server 2005 to Microsoft Access throw VBA code? Quite simple. The problem is finding the correct SQL connection string:
DoCmd.TransferDatabase acImport, “ODBC”, _
“ODBC;DRIVER=SQL Server;” & _
“UID=username;” & _
“DATABASE=databasename;” & _
“SERVER=server;” & _
“PWD=password“, acTable, “table1“, “table1_copy“, False, True
I lost so many hours figuring out what the hell did “Could not find [...]

[ More ] June 14th, 2009 | 1 Comment | Posted in tech |

Bing! A New Search Engine Arises

Microsoft has finally brought up to the search engine market a nice product called Bing in order to replace the Live Search. Thought the strange name, this search engine display some nice results.

There is a comparison site called Blind Search where you can submit a query to Google, Bing and Yahoo but you won’t be [...]

[ More ] June 12th, 2009 | 3 Comments | Posted in tech, webdev |

PoznanFirst MR 2010 360ICNY-36IMG_8897sc00a56192IMG_5821DSC02073Anchor Brewing Companychai in sepia& exp compIMG_0623