[AccessD] A2K: Transfer Database

Hi Guys
Yep Paul was right
The first field had been changed (by me :-(() in testing
and that stuffed everything up. Change the columns headers and away she went <sigh>
Thanks for the replies

DD

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, April 06, 2004 8:02 PM
Subject: Re: [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
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com