HI
I AM EXPORTING A TABLE FROM ACCESS TO EXCEL.

BUT THE CARRAIGE RETURNS IN ACCESS FILE ARE BECOMING VERTICAL BARS IN EXCEL.

IS THERE A WAY WE CAN JUST KEEP THE CARRIAGE RETURN ???



THANKS

Hi,
try to export a query instead of the table and within the query replace all carriage return and line feed characters with just the line feed (Chr(10)). You will need to implement a custom Replace function since you are using Acc97. Acc2000 and higher have a build in one. Check these:
01
02
HTH
Good luck

WHAT IF I AM USING 2000 OR HIGHER ONE

COZ I'VE USED THE BEFORE WHAT DO WE ENTER IN THE FIND FIELD( )
REPLACE WITH ( ) IN THE REPLACE FUNCION TO IDENTIFY AND REPLACE THE CARRIAGE RETURNS.

Hi,
can you turn of caps lock...seems like you are yelling.
In Access 2000 or higher you can use the replace function e.g.:

=Replace([NameOfField], Chr(13) & Chr(10), Chr(10))

HTH
Good luck

what i mean is if we are trying to find and repalce a text or a character
for example if we r trying to find " aabcd" and replacing it with "1234" we will enter these strings in the FIND ,REPLACE fields respectively

but how to find a carriage return and replace it with linefeed????


thanks

thanks verymuch

its working


thank you again

You're welcome.
Glad you got it sorted out.
Good luck on future projects!

still having some problems this replace function deleting some records.


let me explain you clearly about the whole process

first we import data in to our database from excel-in this case carraige returns in excel used to become small square boxes in access.i found a code to resolve this in microsoft knowledge base and resolved this issue.

now i want to send the output data back to excel for my managers review in the same format in which i recieved the input .

when i tried to export the output table o excel in excel instead of showing the carriage returns the date is seperated by vertical bars.


can you help


thanks in advance

So any of the suggestions earlier didn't help at all? Did you create a query and implement either a custom replace function (in Access versions prior to Acc97) or the Replace() function (in all version Acc2000 and higher)?
HTH
Good luck

i did try using the replace() function but the ercords with the carraige returns seems to be missing


thanks