How do I get a Access Form to work in excell, but transfer data to Acess?

P

Pete

I built a workbook in Excell, But I would like to build our customer
base in Access. The problem is I have a sheet in excell for collecting
data on customers, Can I merge a Form into that sheet or does it have to
be totally seperate.
 
B

Bob Miller

My recommendation is to NOT collect the customer data in Excel. Do it
in Access. Ever wonder why it is easy to build a form in Acces to
collect the information but difficult to do the same in Excel. There
is a reason. Access is meant to do this, Excel isn't.
Collect your info in Access and then transfer it to Excel if you can't
do what you want with it in Access. My guess is that you WILL be able
to do most of what you want in Access.
You can begin by Importing the Excel worksheet into Access. If you
have questions about how to do this you can ask the group.
Good luck.
 
M

mscertified

I would do it all in one or the other. Getting the two to work together is
not trivial.
However, you can import Excel data to Access or export Access data to Excel
fairly easily.

Dorian
 
Top