Results 1 to 2 of 2
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    From Word to Access?

    Hi there,



    I have what I thought were Excel documents that contain a lot of information for the new database I'm creating. However, in truth, they are Word files that have been set up to duplicate an Excel spreadsheet.

    Now, I've tried saving them as .txt and .rtf files, then import them into Excel, and this is what I get:
    Click image for larger version. 

Name:	teat 1.jpg 
Views:	11 
Size:	315.1 KB 
ID:	27702
    And what is shown per row is all listed in the first cell of each row.

    Is there any other way to import this information? Or am I doomed to cut, copying and pasting thousands of records?

    Many thanks,

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try text csv . not word nor exec.

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

Similar Threads

  1. Replies: 6
    Last Post: 08-13-2014, 10:32 PM
  2. Replies: 8
    Last Post: 04-14-2013, 01:33 PM
  3. access to word
    By sssandhya89 in forum Access
    Replies: 1
    Last Post: 04-09-2013, 12:17 PM
  4. Call word object and import word fields
    By silverspr in forum Programming
    Replies: 3
    Last Post: 12-10-2012, 11:32 PM
  5. Access to Word - Multiple Word Templates?
    By alpinegroove in forum Programming
    Replies: 11
    Last Post: 06-12-2012, 04:42 PM

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