[AccessD] Export to dBase

Reuben Cummings reuben at gfconsultants.com
Tue Dec 16 15:30:55 CST 2003


Thanks, everyone.

I do have names that duplicate the first 10 letters.  I will check those.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
> Sent: Tuesday, December 16, 2003 5:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Export to dBase
>
>
> Reuben
> Apart from solving this field-name problem there are other implications to
> exporting to dBase via a query rather than via the table. Advantages are
> that you can name the fields what you want, determine the field order and
> determine which fields get extracted (you may not need all). Disadvantages
> are that you determine which fields get extracted (you may want all). That
> last point isn't flippant. If you add a field to a table then the
> export of
> a table name will export it, whereas the export via a query where you've
> created the query columns (which you'll have to do to solve the naming
> issue) won't automatically pick the new field up. Depending on
> what's being
> done with the dbf this may be regarded as a good thing or a bad thing, but
> it needs to be taken into account.
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
> Message date : Dec 15 2003, 10:14 PM
> >From : Reuben Cummings
> To : AccessD
> Copy to :
> Subject : [AccessD] Export to dBase
> I am trying to export some queries to dBase files.
>
> However, on some of the queries I get Error 3191, "Cannot define
> field more
> than once"
>
> Anyone care to explain what's wrong?
>
> Thanks.
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.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
>





More information about the AccessD mailing list