Consulting

Results 1 to 1 of 1

Thread: Word table to Access table problem

  1. #1
    VBAX Newbie
    Joined
    Mar 2017
    Posts
    1
    Location

    Word table to Access table problem

    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.
    Last edited by Thoreau; 03-02-2017 at 01:06 PM. Reason: I found a solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •