Click the External Data tab's "Excel" button to display a dialog box for importing data. This transposition step is the reason for importing your form into Excel first, rather than importing directly into Access. Transposing turns row headings, such as those in your imported form, into column headings. Create a new workbook, and then click the Home tab's "Paste Special" command.Ĭlick the "Transpose" check box of the Paste Special dialog box. Select the imported field labels and data, and then press "Ctrl-C" to copy the selection to the clipboard.
They must be on top of the data before Access can import the form. Although the field labels are separated from the form data, they're on the left of that data.
Adobe Reader adds this character to field labels, which makes distinguishing the labels from the form data easy.Ĭlick the "Finish" button to import the PDF form's labels and data into a new workbook. Type a ")" character in the Other text box control. Check only the "Other" check box, while leaving the remaining check boxes unchecked. Excel displays the Text Import Wizard dialog box.Ĭlick the "Delimited" option, and then click the "Next" button.
0 kommentar(er)
