Using Access to create a form from database text

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I have a huge excel spreadsheet that I want to feed into a
form. How do I go about creating a form in Access that
will allow me to dump the information from excel into the
specified fields in Access???

Please advise - hurry! Thanks!
 
First, go to file -Import - select the file type (xls) select the file and
follow the instructions. You will have to import into a new table, not a
form. It also helps if the first row of the spreadsheet has titles that
Access can use a field names in the table.
Next, design a new form. Source of the form (using the form wizard) would
be the table you just imported.

That should get you started.

Damon
 
Back
Top