excel sheetin access form

H

Howard Brody

If you're just looking for a way to get your data into
Access, I'd tweak the spreadsheet, putting the 'Field
Name' in the first row. Then I'd import the entire
spreadsheet into Access as a new table.

File > GetExternalData > Import

From there, you can build a form to display and edit the
data in the table.

Hope this helps!

Howard Brody
 

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

Add additional information to excel form after original data entry 0
Help creating a search form in Access XP 0
Creating a Chart on form from selected data in query. 0
How do I clear a form? 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Excel Data Transfer Issue (strange situation) 1

Top