copy excelcells into access memofield

  • Thread starter Thread starter ron
  • Start date Start date
R

ron

Hi
When I copy cells from an excelsheet into a textbox
after pasting, the cells are separeated by black verticalblocks in the
textbox.
To get rid of them I delete those colons manually and put some empty
spaces between the
data.

I tried also with search and replace but that doesnt work


160¦packages¦320¦kgs¦
160 packages 320 kgs

Is there an easier way to handle this?

Thanks in advance for your help

Best regards,
Ron
 
It's almost certainly a Tab character (Chr$(9)). You can write an update
query to replace all the tabs with, say, 3 spaces using:

UPDATE MyTable SET MyField = Replace(MyField, Chr$(9), " ")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hi
When I copy cells from an excelsheet into a textbox
after pasting, the cells are separeated by black verticalblocks in the
textbox.
To get rid of them I delete those colons manually and put some empty
spaces between the
data.

I tried also with search and replace but that doesnt work


160¦packages¦320¦kgs¦
160 packages 320 kgs

Is there an easier way to handle this?

Thanks in advance for your help

Best regards,
Ron
 
Back
Top