[AccessD] A2K: Transfer Database

That was my first reaction Paul, then I wondered how that could be when
doing an import rather than an export. The fields on the dbf must already be
unique and a max of 10 chars, cos that's all the dbf would allow. Unless the
dbf is non-standard and was created using something other than the usual
packages. In which case you may be right. Certainly worth a look Darren.
Alternatively have you tried the other similar import types to dBase IV,
like 'dbase III', 'dbase 5.0' and all the Foxpro versions?

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] A2K: Transfer Database
Date: 06/04/04 08:44

>
> Darren,
> try taking a look at the first ten characters of the DBase IV table fields
you are trying to import (i.e. you may have something like StudentsID1 and
StudentsID2 if you look at the first ten characters you will only have
StudentsID) for some reason when trying to Export/Import DBase IV tables it
only reads the first ten characters.  Make sure the first ten characters in
your fields are different and then you should be ok.
> Paul
>
>
>
>
>
> Message date : Apr 06 2004, 06:01 AM
> >From : "Darren DICK"
> To : "AccessD List"
> Copy to :
> Subject : [AccessD] A2K: Transfer Database
> hello all
> can anyone tell me why the acLink version of transfer database
> below works but the import version fails? Along with the error message
> "Cannot define Field more than once"
> I have tried every combination I can think of in relation to the dbf file
name location etc.
> No joy and the help is useless
>
> 'This one works fine
> DoCmd.TransferDatabase acLink, "dBase IV", "C:",
acTable, "C:SIDS.dbf", "tblStudents", False
> 'This one fails
> DoCmd.TransferDatabase acImport, "dBase IV", "C:",
acTable, "C:SIDS.dbf", "tblStudents", False
>
> many thanks
>
> Drren
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> Join the UK's number one for the internet
> www.freeserve.com/time
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2