Import a Form and Data to Microsoft Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DickPutter
    New Member
    • Mar 2013
    • 1

    #1

    Import a Form and Data to Microsoft Access

    I need to fill in a pdf form, which I want to export to Microsoft Access.I prepared an Excel spreadsheet with the data needed to populate the form in Access.I intend to export the spreadsheet to the same Access file. My question is
    1. How can I import the pdf form without losing the visual features of the subject form?
    2. If I export the spreadsheet to the same Access file, how do I get the subject data imported from the spreadsheet,to be mapped in the form, to populate the required datafields of the form.
    3. I would need multiple forms with unique data combinations extracted from the imported data file in the same Access file?
    4. Can any of the members assist with info to create and establish the documents to achieve the mentioned outcomes? I am looking forward to your replies and thank you in advance for the attention herein and hereto. Kind regards,


    Dick Putter
    Last edited by Niheel; Mar 16 '13, 08:17 PM. Reason: spacing and make your questions readable, removed contact information, please leave that information in profile
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Your thread has been moved to the Access forum.

    We only allow one question per thread here so I will only give a quick answer to each of your questions. If you need additional help, please create new threads with only one question per thread.

    1. Create a form in Access that mimics the look of the PDF.

    2. You map the fields in the table to the controls in the form.

    3. I have no idea what you said here. Please create a new thread for it with a better explanation.

    4. Sorry but this is not a service where we do your work for you. We can help with any problems you run into along the way though.
    Last edited by Rabbit; Mar 18 '13, 04:45 PM.

    Comment

    Working...