how to rremove ascii characters imported into access from excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import data from Excel into Access, I get a box shaped charcter
fromthe Excel data representing the ALT + CR. ( This adds a line in a text
based cell)
Seems like the onlu way to fix it is to manually edit every instance.
There should be a better way????
 
You can run an update query.

Use something like this:
UPDATE Table1 SET Field1 = Replace([Field1 ],Chr(13),"")

Tom Collins


| When I import data from Excel into Access, I get a box shaped
charcter
| fromthe Excel data representing the ALT + CR. ( This adds a line in
a text
| based cell)
| Seems like the onlu way to fix it is to manually edit every
instance.
| There should be a better way????
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Help with Importing from Excel into Access 0
Exporting files from Access into Excel 1
Import Excel comments to field in Access 1
Excel Import Into Access 3
Import data from Access to Excel containing VB code 3
Import memo fields from Excel spreadsheet 1
Importing Excel into Access 7

Back
Top