Import Excel form into Access

  • Thread starter Thread starter Linda
  • Start date Start date
Linda,
File | Get external data | etc. will work.
Quicker than that, am pretty sure you can select the excel fields and paste
them into a table
within access. Highlight all fields on the access table if it doesnt work
first go.
 
Linda

In the File menu: Get Extenal Data / Import

Select Microsoft Excel in the "Files of Type box", click
the Import button and follow the prompts
Hope this helps
Rosco
 
The other answers I've seen to your question seem to be dealing with
importing data from Excel, not forms.

As far as I'm aware, you cannot import Excel forms into Access.
 
You must log in or register to reply here.

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

Browse button for access form 1
Importing Excel Spreadsheet into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Import data from Access to Excel containing VB code 3
Access Importing csv daily files into access 2007 1
Help with Importing from Excel into Access 0
Import Excel comments to field in Access 1

Back
Top