Re: Invalid argument - importing dbf from shp-file

Usually that error has to do withthe file name.
Use the old DOS 8.3 file name convention.
Also be sure the column names in the file are 10 characters or less.
Both file name and all column names should be pure alphanumeric - no strange
characters in etiher.
--
Joe Fallon




"Johanna Öhman" <johanna.ohman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B86200FD-F8F0-45E8-BDAF-B7A5412A2748@xxxxxxxxxxxxxxxx
Hi!
I'm trying to import the attribute table of a shp-file - that is a
dbf-file
(from ArcGIS 9.0). It's worked many times before, but now it suddenly
doesn't. I'm trying to figure out what's different about this shp or dbf.

Often I get the message Access can't find the file and to check if the
name
is correct, even though the icon is there to click on. Then it usually
helps
to rename all the 7 files of the shp-file is built up of. But now I'm just
getting "Invalid argument".

What are the criterias a dbf must fulfill in order to be importable? Is
there any other program I can import to first, with a high limit on number
of
rows (I have 260000 rows so excel doesn't work)?

Thanks!


.

Relevant Pages

  • Re: Dbase III field attributes
    ... > What is the largest text or character field attribute in DBF tables? ... > I would like to populate a field with 8000 characters. ... Andrew told you about memo fields, but you mentioned dbase III in a FoxPro ... When you USE a dBase dbf with a memo field, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Linking a dbf file with a filename longer than 8 characters
    ... ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long ... > filenames longer than eight characters. ...
    (microsoft.public.access.externaldata)
  • Re: Creating dbf table using ADO Recordset open method
    ... I will certainly look up more details on the DBF format, ... table name specified is longer than 8 characters is will truncate to 8 ... Names so they were limited to the old Dos 8.3 format. ... Since then other version of "xBase" have appeared, ...
    (microsoft.public.data.ado)
  • Re: How to maintain text characters when converting from xls to dbf f.
    ... I'm used to working with FoxPro DBFs which have a limit of 256 characters in ... characters for field names. ... Maybe DBF IV is the same. ... The dbf format trucates my text (in addition to the column ...
    (microsoft.public.excel.misc)
Loading