Microsoft excel and ms access

  • Thread starter Thread starter sAMBEDAn kOIRALa
  • Start date Start date
S

sAMBEDAn kOIRALa

I have 40 forms that I need to fill in and generate reports. I don't want
to use access for this purpose, neither I want to use PHP programming. I am
wondering whether or not it is possible to use excel as an entry form and
access database as a data recording unit. Plz. Suggest

Regards
Sam.
 
I have 40 forms that I need to fill in and generate reports.  I don't want
to use access for this purpose, neither I want to use PHP programming.  I am
wondering whether or not it is possible to use excel as an entry form and
access database as a data recording unit.  Plz. Suggest

Regards
Sam.  
Click to expand...

I guess if you don't want any kind of data validation, then Excel
would work. Completely ass-backwards, but it's a free country. Knock
yourself out.
 
Nah.. Not the answer I'm luking 4.

Cheers.



I guess if you don't want any kind of data validation, then Excel
would work. Completely ass-backwards, but it's a free country. Knock
yourself out.
Click to expand...
 
And why are you thinking that using Excel forms to store data into an Access
database will be simpler than simply directly using Access forms or if is
there any other particular reason?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Just trying new things n xploring new techniques. Excel is easy to use for
most of the people that's why. Anyway, thanx for the responses. Let me
search the net n c whether it's possible or not.

Cheers.
 
The first responder already answered, the answer is yes.

Just like the question of whether you can hammer a nail with a wrench. The
answer is yes,.....not a new idea, not a good idea.

An Access form would address user familiarity issues much better than a
spreadsheet.
 
Back
Top