Re: New line in field

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 22:09:57 +1000

If you are using A2K or later, you can use the Replace() function in an
Update Query to replace the NewLine + CarriageReturn with a marker that
doesn't affect your import.

If you are using A2K, there is a bug with Replace in Query and you will need
to write a "wrapper" function.

OTOH, you may be able to export from Access (or import ) to the other
database format without going through the intermediate Text-file step. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Mo" <m.a.joomun@qmul.ac.uk> wrote in message
news:c490ol$9t4$1@beta.qmul.ac.uk...
> I have just inherited a db and now need to export data from this db into a
> fixed-width text file.
>
> The problem I'm having is with an address field. On the form where these
> addresses were entered, 'New Line in Field' has been selected for the
'Enter
> key behaviour' option. This allows users to use the return key to
> effectively add a new line in a text box for each line of the address.
Only
> some of the addresses in the table have been entered with 'new lines' so
to
> speak.
>
> This causes a particular problem when exporting  In my text file, each
time
> there is a record where the address field has been input using this
option,
> it is being interpreted as a new record.
>
> Is there a way to format the address field to remove this behaviour
> entirely, perhaps in a query?
>
> Thnaks for any help.
>
> Mo
>
>

Relevant Pages

  • Re: Importing Large List
    ... If you have that many records then I am assuming they are in database format, ... which case if you have Access you could dump them in there and then query them ... from Excel with a Pivot Table or just an ordinary MSQuery. ... to query them from Excel right where they are now, but it depends on where they ...
    (microsoft.public.excel.worksheet.functions)
  • Re: QUERY EXCEL TABLE DATA
    ... You can use Microsoft query to extract from Excel files - just make ... sure your queried file is in database format - all columns contain the ... Import External Data - New Database Query. ... Data Source and navigate to the workbook and sheet you want to query. ...
    (microsoft.public.excel.programming)
  • Re: Tracking records that have been deleted
    ... If you want true Audit Trail do not allow the system to physically ... "deleted" along with the marker. ... ensure you query the new field to check that it is set to false. ... > either from rescheduling appointments, canceling appointments, to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: join type not supported
    ... and the query works. ... We are presuming here that the marker field is the same data type in both ... Allen Browne - Microsoft MVP. ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.queries)
  • Re: Null Values
    ... > Can i replace Null with space in the select query ... NULL is a marker for a missing value. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)