Excel importing into Access

[credo]

Hello,
I have an excel spreadhseet with two columns that I want to import into Access 2000 (through the normal File>Get External Data). Problem is, one of the columns in the Excel spreadsheet has line breaks in the cell. When importing into Access these lines get put into separate "rows".

How can I strip out the line breaks from the Excel sheet automatically (over 1000 records) before importing into Access?

Any help appreciated.

 

[mikey69]

The line break is ASCII 010. You should be able to search and replace.

Alternatively take the table into Word and do the search and replace there - use ^l as the search argument. Generally speaking Word has more flexible and powerful search and replace facilities, and it's usually not too difficult to port from one aplication to the other.