MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can you open an excel form in access?


Posted by Joyce on November 05, 2001 12:02 PM

We have a number of forms already created using excel, and now we want to use them to create an access database. I've never seen this done.
Has anyone?
J


Posted by Ziggy on November 10, 2001 7:38 PM

Joyce,

Try this I'm not sure if this is exactly what your looking for:

Open a new form or report in design view, select which table/query you want to take the data from.

Then Copy your Excel form and paste it in the detail section in Access

You can then take your field list and drag and drop the fields where you want them.

This should work I'm not an expert but I've played around with this myself.

Good Luck

Ziggy