Spreadsheet as data entry form

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

I wish to use some of my excell files as dataforms so I will have all
information straight away in database, are there any good ways to do
such a thing or my idea is crazy ?

regards
Peter
 
Hi Peter

my "database" do you mean in excel or in a database program?
either can be achieved (although i've not had much experience with writing
from excel to a database).
if you mean a database (ie flat file - records running across rows and the
fields in columns) in excel, then one place to start is to create your
"database" (put the headings in row 1) and then as long as you've got less
than 30 columns you can use data / form from the menu.

if you'ld like to provide additional information i'm sure we can come up
with other ideas for you - most, however, will probably involve some VBA.
 
Back
Top