Default Values within fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William - 18 Jul 2005 11:24 GMT

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.

Signature

Hangnail

Reply to this Message

Jeff Boyce - 18 Jul 2005 12:26 GMT

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>

> 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.

Reply to this Message

William - 18 Jul 2005 13:12 GMT

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.

Signature

Hangnail

> William
>
[quoted text clipped - 17 lines]
> > export them with this already completed it'll save me hours of work doing
> > them within Excel the whole time.

Reply to this Message

Jeff Boyce - 18 Jul 2005 15:02 GMT

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.

Signature

Regards

Jeff Boyce
<Access MVP>

> Yes. But the fields that I have to export look as shown below as an example.
>
[quoted text clipped - 30 lines]
> > > export them with this already completed it'll save me hours of work doing
> > > them within Excel the whole time.

Reply to this Message