Outlook Excel forms to Access

W

Wackroundball

Daily get e-mails with excel spreadsheet forms attached(all same fields &
format). I usually copy and paste the fields I need to an Excel template from
each form to create a larger spreadsheet of data. Then I export the large
spreadheet into Access. Is there a way to open each e-mailed form, and maybe
add a command button to an Access form that would pull the data all at once,
rather than copy & paste? Would that be easier than trying it in a VB program?
Example:
field 1 fld 2 fld 3 f4 fld5 fld6
fld7 f8 f9
J577-001 OEMPALLET 0001 RB1 PWRTRANS PWT SEALING PWTSEAL 0001 RB1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Data in an Access Form to fill in Excel Spreadsheet 2
Import a Excel spreadsheet into a Text comments field on a form 1
Importing Excel Spreadsheet into Access and Changing Field Propert 7
Dumping Data into an Access Form using Datasheet view 5
import an Excel "form" into an Access "form" 3
Hard Returns from Excel are Lost 3
Excel "Form" Data into Access 5
Link from Excel to Access Table Not Allowing Data Entry on Form 1

Top