Go Back   Access World Forums > Microsoft Access Discussion > General

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 11-13-2019, 09:15 PM   #1
Disabledg
Newly Registered User
 
Join Date: Nov 2019
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Disabledg is on a distinguished road
Access 97 remove line breaks

Hello! I have old mdb base with invisible line break. After export to excel i got new lines - and it brokes data structure.

How can i remove line breaks from datatable?

UPDATE table1 SET attr1 = trim(attr1) dont help.
UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") not working - replace function not exist in access 97.

Disabledg is offline   Reply With Quote
 

Tags
access97 , linebreak

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Carriage Returns/Line Breaks in Field As Soon As Pasted. zashaikh Forms 2 01-04-2018 07:26 AM
Code to remove line breaks in table reedhillltd General 4 06-22-2014 08:51 AM
Trim/Remove line breaks from every field in every record NeutronFlux Modules & VBA 8 12-06-2012 01:07 PM
Remove Line Breaks Dmak Modules & VBA 2 09-25-2012 06:40 AM
Question How to remove line breaks from a table? mark_m General 2 02-23-2009 05:23 AM




All times are GMT -8. The time now is 12:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World