Possible to recreate an Excel spreadsheet in Datasheet view?

[djrickel]

I am so desperate for help on this. I know it must be possible but am lost on how to get started.

We have a spreadsheet in Excel that I need to recreate in Access rather than link to it (not an option). I would like to create it column by column but can't even get past column 1!

We have two age fields; 1) current age and 2) "show till" age. I need the datasheet to autofill column 1 beginning with the current age through the "show till" age then stop.

Column 2 begins with the current year and autofills through the "show till" age then stop.



In Excel it's just a matter of adding 1 to the previous cell to create the next age or year. How can I do this?

Thanks.

[JeroenMioch]

Access works different from excel as u now know.
In design mode open up your table.
Just add row underneath your first one to add a column to the database.

It might look like your addidng a row, but it is in fact a column.
The rows (in datasheet mode) are the records ..

[djrickel]

I attached a copy of a sample spreadsheet that needs to be recreated in Access. Please look this over and give me some direction.

Thanks again!

[June7]

Access is a relational database application and its primary function is to manage data, not really a statistical analysis tool, although it can be made to do some. It doesn't work like Excel. There is no calculated 'autofill' feature for a table. At Access's most basic functionality, tables require data entry (typing) to create records. However, code can be written to create records. Also, Excel sheet can be imported into Access.

You need to study some elementary references and gain a better understanding of relational database principles, Access functionality, and programming concepts. There are tutorials available through this forum site.

[JeroenMioch]

I looked over your excel sheet and i must say it will not be easy to create it if you are a novice at Access, unless you have loads of time and are very commited.

You have to be able to make a table that holds the relevant data, and a form to match.
It's not that we're not willing to help (why would we be here if we didn't) but to explain Access from ground level then it's gonna be a very lengthy post