Is that a quick way to import Excel form into Access?
P Peter D Sep 27, 2004 #2 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, 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.
R Rosco Sep 27, 2004 #3 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
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
D Douglas J. Steele Sep 27, 2004 #4 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.
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.
