Really need help importing a CSV file

[hunterl]

I really need help with this one. I have a csv file that i import via excel. Everything works fine,except in my memo field I have square boxes which I can strip out easily enough by removing Chr$'s 10 and 13. The problem is I actually need the carriage return so it prints correctly in the report. So how do I remove the boxes and keep the formatting. Thanks.

 

[cottontop]

To be clear...

Which scenario fits:
1. You create a CSV file in Access. You import the CSV file into Excel.
From access, you can export the table as an XLS file with formats intact. From the menu, slect file,export. Then change the file type to the Excel you need. Then select "save formatte" and "autostart". That will keep the formatting intact and it will automatically start Excel to display the import!

2. You create a CSV file in Excel. You import the CSV file into Access.
Instead of pulling in the CSV in Access, just import the XLS! In Access, use menu: File, Go to, Import. Change the file types to excel and select the XLS.

Hope this helps!