Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Thanked 0 Times in 0 Posts

    importing docs n2 access (access 2000)

    i have several addresses & names n word 2000 that i need 2 get n2 an existing table n access 2000. is there an easier way than just 2 copy/paste. if i do copy/paste can anyone recommend a format 2 use?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts

    Re: importing docs n2 access (access 2000)

    You can import data from Word, provided there delimiters in word (something to indicate the end of one field and the start of the next, end of one record start of next). A table with each record on one line, each field in a cell would do, or just a delimit character like a comma would do.

    Is your word data in such a format? could you put it into a format like that?

    If so, you then use File...Get External Data... Import to bring it into Access. You can either add it to an existing table or create a new one. I think it is safer to create a new table, then if all seems OK, use an append query to move it to the table you want it in.

Posting Permissions

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