Re: [mdb-dev] Unknown field type

[Brian B. <ca...@ai...>]

I've never seen a field type 0. 

Can you do this...(assuming you have compiled from source)

cd src/util
../extras/mdb-dump PlotData.mdb `./prtable PlotData.mdb PlotDataForDendron_ExclFSMArea |grep 'definition page' | cut -f2 -d=` | head -300

And post the results.

Brian

On Thu, 23 Jan 2003, Vytas Janusauskas wrote:

> Hi Folks,
> 
> My search of the archives may have missed reference to the cause of this 
> problem.  If that is the case my apologizes.
> 
> I am trying to export a table from an Access 2000 database.  I manage to 
> extract 3 out of 4 fields.  The missing field (field 2) gets exported as a 
> null string.
> 
> If you require a copy of the database just let me know.
> 
> Below is the output I get from mdbtools.
> 
> Thanks,
> 
> Vytas
> 
> mdb-ver PlotData.mdb
> 
> JET4
> 
> mdb-schema PlotData.mdb
> 
> DROP TABLE PlotDataForDendron_ExclFSMArea;
> CREATE TABLE PlotDataForDendron_ExclFSMArea
>   (
>          Plot #                  Text (8),
>          Field Cover Type                        Unknown 0x00 (6),
>          Species                 Text (100),
>          DBH                     Text (4)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> 
> 
> -- CREATE ANY Relationships ...
> 
> relationships are not supported for access
> relationships are not supported for access
> relationships are not supported for access
> relationships are not supported for access
> relationships are not supported for access
> Segmentation fault
> 
>   mdb-export PlotData.mdb PlotDataForDendron_ExclFSMArea
> .....
> "6466",,"Spruce","10"
> "6466",,"Spruce","10"
> "6466",,"Spruce"," 4"
> "6467",,"Fir"," 4"
> "6467",,"Fir"," 4"
> ....
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>