[AccessD] Export to dBase

WHAT!!!

And now you're telling me...
All those years I had to use all of my (limited) imagination to think of
some cryptic 8 character fieldnames wile I had 10 :-)

I feel like I been had :-)

Erwin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Tuesday, December 16, 2003 8:43 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Export to dBase

Iirc the limit's 10 but it may vary by version. But I agree that's the
problem. The export simply truncates your field names and if you have
two which are not unique within the first 10 characters then you get
this. As Erwin suggests, create a query where you can dictate the output
names, and export that.

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

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps

> - IT Helps
> Sent: 16 December 2003 07:26
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Export to dBase
> 
> 
> DBF is limited to 8 character fields names (can be different depending

> on DBF version).
> 
> I don't remember exacly what happends in access if you have for 
> example txo field named:
> 
> CustAddressLine1
> CustAddressLine2
> Both could be truncated to CustAddr.
> 
> Create a query putting your own fieldnames at 8 chars like this. 
> CustAdd1 :[CustAddressLine1] CustAdd2 :[CustAddressLine2]
> 
> Erwin Craps
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie 
> Johnson
> Sent: Tuesday, December 16, 2003 2:39 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Export to dBase
> 
> When I get this message it's when I have taken a field from the table 
> and moved it on the grid more than once.
>  
> 
> 
> Reuben Cummings <reuben at gfconsultants.com> wrote:
> 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
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> Lonnie
> Johnson
> ProDev, Professional Development of MS Access Databases Visit me at 
> ==> http://www.prodev.us
> 
> 
> 
> 
>  
> 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com