Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2011
    Posts
    2

    Import a list of names from Word to access

    How do you Import a list of names, addresses and info from Word to access?

  2. #2
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123
    Quote Originally Posted by WickedGoodOutdoors View Post
    How do you Import a list of names, addresses and info from Word to access?
    Unfortunately, this is probably a can of worms...

    Best bet is to reformat the Word doc so that each "row" of the list takes up one line of data, with a tab between each item. If it's formatted like:

    FirstName LastName
    Address
    City, State Zip

    Change it to look like:
    FirstName[tab]LastName[tab]Address[tab]City[tab]State[tab]Zip

    This can be done using several global search-and-replace steps.

    Then, save the word doc as a Plain Text file, and import into Access as a tab-delimited text file. Better yet, pull the Plain Text file in Excel first to make sure everything drops into the columns where you expect it, then import the Excel file into Access.

    Best I can do for you -- Word & Access are such different animals when it comes to data formatting that this is the best avenue I've found over the years.

    Steve

  3. #3
    Join Date
    Jan 2011
    Posts
    2
    The Word File is hundreds of thousands of names.

    some names have the first name firt, some last name first, some no person but only a business name. some have the emails & website & Tell # & Cell Phone & Fax and others dont.

    It is in no particualr order.

    some names even have the companies logo stuck on it.


    any suggestions?

  4. #4
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123
    No, sorry.

    As I said, a can of worms.

    Take the time to do the reformatting yourself, hire a temp to do it, see if there's a service out there somewhere that will do it for you. Other than that, I'm out of ideas.

    Steve

Please reply to this thread with any new information or opinions.

Similar Threads

  1. File Names in "Open Recent Database" list
    By Ron.Sul in forum Access
    Replies: 3
    Last Post: 12-29-2011, 10:06 AM
  2. Import file list
    By pittpa1958 in forum Import/Export Data
    Replies: 4
    Last Post: 07-07-2011, 04:57 AM
  3. Loop through a list of table names and compare
    By mikneus in forum Programming
    Replies: 1
    Last Post: 05-21-2010, 10:36 AM
  4. Replies: 1
    Last Post: 05-17-2010, 12:21 PM
  5. How to import word and PDF files into Access
    By asaini in forum Import/Export Data
    Replies: 1
    Last Post: 09-03-2009, 11:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums