Default Values within fields

[William]

I want to enter the following into a field as a default descriptor ,"SE", and
"," and ," as examples. These are for replications that have to take place
from the Access Database that contains the information to a server that can
only interpret comma deliminated values from a text file. Therefore if I can
export them with this already completed it'll save me hours of work doing
them within Excel the whole time.

 

[Jeff Boyce]

William

Are you saying that you need a way to export comma-delimited data?

If so, check out Export (Files | Export) ... If I recall correctly, you can
specify the format of the export.

Good luck

Jeff Boyce
<Access MVP>

 

[William]

Yes. But the fields that I have to export look as shown below as an example.

1,"In",688342,"67","

The number I can do via autonumber. The ,"In", may differ from file to file.
It may be ,"In", or ,"Se", etc. The the other values being the ," and the ","
are values that I would like to enter as default values seeing as they differ
in position and construction from file to file. Thanks for the help, I will
give this a bash but, if you could perhaps help me with this to automate the
process completely will be brilliant.

Thanks again.

 

[Jeff Boyce]

William

We're in the tablesdbdesign newsgroup, so I'll assume you are trying to do
this in a table.

Make your life much easier -- do this using a query. You can do all the
massaging in your query, and Export works on queries as well as tables.