Word table to Access table problem

[Euler]

Hello,



I've written some VBA code in Access that allows a user to select a Word file with one table in it and then goes through that table and imports the data from the second column. The problem is with the format of the data when it gets into the Access table. Each item of data has "[]" after it. I'd like to get rid of those brackets and just show the clean data in the table but I don't know how. Can someone help?

Thank you.

Sorry, I found a solution. I just used the Replace function to replace "" with "". It works so I'm good.

[ranman256]

take the data in between,
sData = mid([field],2,len([field])-1)

[Euler]

take the data in between,
sData = mid([field],2,len([field])-1)

Thanks
for
responding.