Results 1 to 2 of 2
  1. #1
    asaini is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    1

    How to import word and PDF files into Access


    Hi,

    I am new to this forum.

    Following is my query:

    I have two documents one in word and another in PDF format.

    I want to import word document into an access as a Form. This word document has fields: Name, address, date of birth etc.

    When I enter the data in this form I want it to be saved to access database (so that data can be accessed as and when required)

    Next step..



    I want to add .PDF into access as form as well. This also has fields such as Name, Address, date of birth etc (same as above). I want these fields to be automatically populated with data from first form.

    Please suggest how should I go about this. I am Systems Admin by profession, not very good at programming.

    Your help will be much appreciated.

    Adarsh

  2. #2
    Ryan is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2009
    Location
    Lafayette LA 70592
    Posts
    26

    Lightbulb How to Import

    Import the Word Document to Excel, then import the Excel Document.

    How To Convert Word to Excel:


    If you want to import a text file into Excel and have that data be in multiple columns once it's in Excel, it must be either fixed width or delimited. Fixed-width means that new columns occur at the same place on every line. That's not very useful for most information. Delimited means that some ASCII character occurs wherever you want a column break. Usually this character is a tab. If you had address information and wanted the Street, City, and State in different columns, your data would have to look like:
    Street {tab} City {tab} State
    If you have your data in a table in Word, you're going to want to convert it to text. When you select Table > Convert > Table to Text, Word will ask you what it should separate the text with. In other word, it wants to know what it should use as the delimiter. You can use any ASCII character, but I would suggest a tab or some other character that isn't use in your data. Whatever you choose, just remember to tell Excel to use it as the delimiter when it imports your data. If you data in Word and is *not* in a table, just save it as Text Only With Line Breaks (.txt) so that every line goes in a different row (assuming that's what you want). When in Excel, you can use Text to Columns to parse it into different columns.

    As for as the PDF, there are programs out there like "able2extract" that has free trials for 7 days. You can use that to convert the PDF to excel.

    Remember, after its Excel, you can simply import it.

    Hope this helps!

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

Similar Threads

  1. Import multiple text files automatically
    By instructorTek in forum Import/Export Data
    Replies: 30
    Last Post: 10-20-2012, 04:50 PM
  2. Upload files to access 2007 through web
    By karthikcoep in forum Programming
    Replies: 0
    Last Post: 08-23-2009, 10:04 PM
  3. Importing Xls and CSV files into MS Access
    By Jeff in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2009, 11:56 PM
  4. Access Question regarding JPEG files
    By amosstarz in forum Security
    Replies: 1
    Last Post: 09-01-2006, 04:17 PM
  5. Import multiple dbf files into existing table?
    By sbg2 in forum Import/Export Data
    Replies: 0
    Last Post: 06-12-2006, 02:06 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