Excel to Access (or something)

[aragno]

I have created a form in Excel that I want to use to fill i
information, and then have it save the information in a database.

The form is NOT simply in rows and columns, it has graphics and so on


I want to simply fill in all the information, and then have it save i
to a database, where I can later run different queries to find specifi
data that was entered into specific cells.

If anyone could help, I would be extremely grateful. I've been messin
around with it for hours and have had no luck.

I once saw a co-worker create a form in Excel that had the options a
the bottom to move to the next record, etc... just like you would se
in the form view in Access.

Thanks a million!!

-Tre

 

[Peo Sjoblom]

Your co-worker maybe used data>form? Regardless you can build a userform
using VBA or use something already existing like JohnWalkenbach's enhanced
data form

http://j-walk.com/ss/dataform/index.htm

a little bit about userforms

http://j-walk.com/ss/excel/tips/userformtips.htm





--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[aragno]

i took a look at that form. That is pretty nice, but I have approx. 5
fields total to enter data into, and that form would get very long an
tedious. The form I have created in excel is very userfriendly, bu
would like to input the data directly from that