Hi guys, > Date: Wed, 29 Sep 2010 16:01:08 +0200 > From: Micha Silver <[email protected]> > Subject: Re: [Qgis-user] Newbie Questions > To: Michael Lapson <[email protected]> > Cc: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > On 09/29/2010 03:17 PM, Michael Lapson wrote: > > > > > > I am indeed using Excel 2007 and I am hoping for a workflow that goes > > directly from Excel to GIS since I do that very often. I tried the > > "Value,N,10" trick you describe above but I get an error that the > > field name is longer than 10 characters. I assume the CSV table join > > feature will be fixed in the next release of QGIS. Is there a way to > > report and track a bug like this? > > Maybe I didn't explain myself clearly enough. In order to have QGIS > import a column as numeric values you *must* use a dbf file as the > linked table. MS, in their wisdom, dropped support for dbf with Excel > 2007. So your better option is to download and install Openoffice.org, > and use the Excel equivalent - Calc
I'd rather use OOo myself, but if you do insist on using Excel 2007/10 there is a donationware addon to add .dbf write support. I imagine there are other solutions too. http://thexlwiz.blogspot.com/ Regards, Alister _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
