[Qgis-user] RE: creating dbf from excel (was: Newbie Questions)

Alister Hood alister.hood at synergine.com
Wed Sep 29 17:01:24 EDT 2010


Hi guys,
 
> Date: Wed, 29 Sep 2010 16:01:08 +0200
> From: Micha Silver <micha at arava.co.il>
> Subject: Re: [Qgis-user] Newbie Questions
> To: Michael Lapson <michael.lapson at ascendworldwide.com>
> Cc: qgis-user at lists.osgeo.org
> Message-ID: <4CA346A4.6090906 at arava.co.il>
> 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


More information about the Qgis-user mailing list