How To Import From A PDF Form To Access
How To Import From A PDF Form To Access
How To Import From A PDF Form To Access
com
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
https://smallbusiness.chron.com/import-pdf-form-access-57725.html 2/2