Aug 22 2007, 02:47 PM
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 ???
Aug 22 2007, 02:58 PM
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
Aug 22 2007, 03:10 PM
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.
Aug 22 2007, 03:14 PM
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))
Aug 22 2007, 03:16 PM
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????
Aug 22 2007, 03:21 PM
thank you again
Aug 22 2007, 03:29 PM
Glad you got it sorted out.
Good luck on future projects!
Aug 22 2007, 03:59 PM
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
Aug 22 2007, 04:27 PM
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)?
Aug 23 2007, 08:27 AM
i did try using the replace() function but the ercords with the carraige returns seems to be missing
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here