Using Access to create a form from database text

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!
 
D

Damon Heron

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
 
Top