<\/div>

Be careful about the type of data assigned to your coordinate fields\n(here Google_Longitude and Google_Latitude). According to an algorithm that has\nalways escaped me, switching from Excel cell format to data type to database\nhas some odd results. You may end up with text-type coordinate fields. In this\ncase, there will be no errors displayed thereafter, except that your geometry\nwill be zero and you will have no point in the display. It is therefore at this\nstage that we must correct the shot, after it will be too late and it will\nstart all over again. <\/p>\n\n\n\n

If your X and Y fields are in text, open a SQL window in the\ndatabase manager (second button of four) then enter one by one the following\nSQL queries to create a new numeric field and fill it with the contents of the\ntext field: <\/p>\n\n\n\n

ALTER TABLE your table<\/em> ADD Xm double precision
\nUPDATE your_table<\/em> SET Xm = X
\nALTER TABLE your table<\/em> ADD Ym double precision
\nUPDATE your_table<\/em> SET Ym = Y <\/p>\n\n\n\n

where X and Y are your text fields. <\/p>\n\n\n\n

[\/ stextbox] <\/p>\n\n\n\n

At this point, the import of the table is complete. However, since the\ncoordinates are present in the table, you can create a point geometry column\nand add it to the table. This will transform the table into a layer of\npoints. <\/p>\n\n\n\n

How to add a<\/strong> geometry<\/em><\/strong> column<\/strong> 1. With the hotels<\/em> table selected in the tree view, click \u00a0\u00a0 Table |<\/em><\/strong>Edit<\/em><\/strong>the Table<\/em><\/strong> to open the Table<\/em><\/strong>Properties<\/em><\/strong> window . \u00a0\u00a0 <\/p>\n\n\n\n