Using Excel sheet for an Access form

  • Thread starter Thread starter Yannick
  • Start date Start date
Y

Yannick

Hi everyone!

I've made a couple a excel sheet about 3 monh ago, and
I decide to use Access to compile the result, I what to
use my excel sheet in a form so the user wil enter all the
data directly in access, for that I don't what to make a
new form but use my excel sheet were I have some formula
in it too. I try to insert with insert/object/file but I
can't see all my page in the form, or sometimes I can but
with I go to the mode to enter data I loose the end of the
sheet.

Do ou have any idea to solve this problem.

Thank you
 
I don't think you can do this. If the user made an entry, how would Access
store it? What field would it go to?

If you don't care about storing the results, then why are you using Access?
Just let them open the spreadsheet.

Not sure why you would want a hybrid of Access and Excel.

Rick B

Hi everyone!

I've made a couple a excel sheet about 3 monh ago, and
I decide to use Access to compile the result, I what to
use my excel sheet in a form so the user wil enter all the
data directly in access, for that I don't what to make a
new form but use my excel sheet were I have some formula
in it too. I try to insert with insert/object/file but I
can't see all my page in the form, or sometimes I can but
with I go to the mode to enter data I loose the end of the
sheet.

Do ou have any idea to solve this problem.

Thank you
 
Back
Top