Hi,
Is the name of the column "X Coord" or "X_Coord" or "XCoord"
?
If the first is the name of you column, I will suggest that you rename
it, so that the space is removed
Peter Horsbøll Møller
GIS Developer, MTM
Geographical
Information & IT
COWI A/S
Odensevej
95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
"For enden af
regnbuen..." - hvordan kommer man dertil og er
det overhovedet muligt?
Læs mere om årets MapInfo konference på
www.cowi.dk/mapinfokonference
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Smith
Sent: Wednesday, July 19, 2006 10:52 AM
To: mapinfo-l@lists.directionsmag.com
Subject: [MI-L] DBMS problems; making tables mappable.
Hi
All,
I'm having trouble
mapping data from an Access 2000 database in MapInfo version 8. I
have created the Map Catalogue for the DBMS connection, using the
Microsoft Access .mdb machine data source and MapInfo tells me that the
Catalogue item has been created successfully.
Then, using the Make
DBMS Table Mappable tool, I've selected the table from Access that I would
like to create points from and have told MapInfo which columns I would like to
use for X and Y coordinates. The columns in the Access table are
set up as number; double, yet MapInfo tells me that the column 'X Coord' doesn't
exist in the Access table and therefore ends the process of making the table
mappable.
I don't know why
this happens; I've tried (in MS Access) changing the X Coord column to
integer and long integer and get the same errors. The table isn't linked
or anything; it was imported from an Excel spread sheet, but is now independent
from it.
I would be grateful
for any advice on this.
Best
regards,
Robin
Smith
GIS
Assistant
GIS team,
ICT
South
Gloucestershire Council
01454
863407
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l