[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