Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    How To Import From A PDF Form To Access

    Uploaded by

    Elijah Wisdom
    This document provides steps to import data from a PDF form into Microsoft Access. It explains that PDF forms are difficult to directly import into Access, but can be converted to Excel first. The steps are: 1) Export the filled PDF form to text using Adobe Reader 2) Import the text file into Excel using the Text Import Wizard 3) Copy the data and labels and paste into a new Excel workbook, transposing the rows and columns 4) Save the Excel file and import it into a new Access database, selecting the "First Row Contains Headings" option to import the data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    How To Import From A PDF Form To Access

    Uploaded by

    Elijah Wisdom
    19 views2 pages
    This document provides steps to import data from a PDF form into Microsoft Access. It explains that PDF forms are difficult to directly import into Access, but can be converted to Excel first. The steps are: 1) Export the filled PDF form to text using Adobe Reader 2) Import the text file into Excel using the Text Import Wizard 3) Copy the data and labels and paste into a new Excel workbook, transposing the rows and columns 4) Save the Excel file and import it into a new Access database, selecting the "First Row Contains Headings" option to import the data.

    Original Description:

    How to Import From a PDF Form to Access

    Original Title

    How to Import From a PDF Form to Access

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides steps to import data from a PDF form into Microsoft Access. It explains that PDF forms are difficult to directly import into Access, but can be converted to Excel first. The steps are: 1) Export the filled PDF form to text using Adobe Reader 2) Import the text file into Excel using the Text Import Wizard 3) Copy the data and labels and paste into a new Excel workbook, transposing the rows and columns 4) Save the Excel file and import it into a new Access database, selecting the "First Row Contains Headings" option to import the data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    19 views2 pages

    How To Import From A PDF Form To Access

    Uploaded by

    Elijah Wisdom
    This document provides steps to import data from a PDF form into Microsoft Access. It explains that PDF forms are difficult to directly import into Access, but can be converted to Excel first. The steps are: 1) Export the filled PDF form to text using Adobe Reader 2) Import the text file into Excel using the Text Import Wizard 3) Copy the data and labels and paste into a new Excel workbook, transposing the rows and columns 4) Save the Excel file and import it into a new Access database, selecting the "First Row Contains Headings" option to import the data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    8/31/2019 How to Import From a PDF Form to Access | Chron.

    com

    How to Import From a PDF Form to Access


    by Darrin Koltow

    One benefit of collecting your business data with PDF forms


    is security -- unlike Excel or HTML forms, for example, PDF
    forms are harder to alter, as you need a special program with
    PDF editing capabilities. The benefit comes with a cost,
    however: Access can't import PDF form data directly, as it can
    from Excel and other sources. Use Adobe Reader and Excel as
    a solution to this problem. Reader's ability to export text, and
    Excel's ability to convert text into table data, let you convert
    PDF forms into an Excel workbook that Access can import.

    1. Open a filled out form in Adobe Reader. This PDF form must have field labels on the left and filled fields on the
    right. Click the "File" menu's "Save as other" item. Click the "Text" item, and then enter a file name in the dialog box
    that appears. Click "Save" to save the form as text.

    2. Open the exported text file in Excel. Excel displays the Text Import Wizard dialog box.

    3. Click the "Delimited" option, and then click the "Next" button. Check only the "Other" check box, while leaving the
    remaining check boxes unchecked. Type a ")" character in the Other text box control. Adobe Reader adds this
    character to field labels, which makes distinguishing the labels from the form data easy.

    4. Click the "Finish" button to import the PDF form's labels and data into a new workbook. Although the field labels
    are separated from the form data, they're on the left of that data. They must be on top of the data before Access can
    import the form.

    5. Select the imported field labels and data, and then press "Ctrl-C" to copy the selection to the clipboard. Create a
    new workbook, and then click the Home tab's "Paste Special" command.

    6. Click the "Transpose" check box of the Paste Special dialog box. Transposing turns row headings, such as those in
    your imported form, into column headings. Click "OK" to perform the transposition. This transposition step is the
    reason for importing your form into Excel first, rather than importing directly into Access.

    7. Save the workbook, and then open Access. Click the External Data tab's "Excel" button to display a dialog box for
    importing data. Click the "Browse" button, and then select the Excel workbook. Click "OK" on the current and next
    screens.

    8. Check the "First Row Contains Headings" check box, and then click "Finish" to complete the import of your PDF
    form data.

    Warning

    Information in this article applies to Adobe Reader XI, Excel 2010 and Access 2010. It may vary slightly or significantly with
    other versions or products.

    https://smallbusiness.chron.com/import-pdf-form-access-57725.html 1/2
    8/31/2019 HowPlay
    Yastrzemski's outstanding diving catch is the #2 MLB to Import
    of the From
    Day a PDF Form to Access | Chron.com

    References (3)
    Adobe Reader: Save As Text
    Microsoft Excel: Text Import Wizard
    Access: Import Excel Data
    About the Author

    Darrin Koltow wrote about computer software until graphics programs reawakened his lifelong passion of becoming
    a master designer and draftsman. He has now committed to acquiring the training for a position designing
    characters, creatures and environments for video games, movies and other entertainment media.

    Photo Credits
    Jupiterimages/Pixland/Getty Images

    Cite this Article

    https://smallbusiness.chron.com/import-pdf-form-access-57725.html 2/2

    You might also like