Using a spreadsheet in Access

[Anne]

Hi

I'm trying to create a spreadsheet within an Access database. I've figured
out how to create a spreadsheet, but can't work out how to create it so that
I can input different data to the spreadsheet for each record. Is there a
way of doing this?

Any help would be appreciated

 

[Randy]

Hi

I'm trying to create a spreadsheet within an Access database. I've
figured
out how to create a spreadsheet, but can't work out how to create it so
that
I can input different data to the spreadsheet for each record. Is there a
way of doing this?

Any help would be appreciated

I don't get it. Are you an Excel user migrating to Access?
In Access: "tables" (data grid) are destinated for data storage and "forms"
are for data entry.
If you created a table and want to input data, please create a form using
the Form Wizard.
Please explain, send us more details.

-Randy

 

[Lynn Trapp]

Access is NOT a spreadsheet and you cannot create spreadsheets in it. I
realize that the datasheet view of a table LOOKS LIKE a spreadsheet but it
is not. Use Excel for spreadsheet applications.

 

[Craig Hornish]

Hi,
Actually you can create a spreadsheet in Access, and I think Lynn knows
this. It is called OLE Object and it it a type that you can assign to a
field. You can also put in a Word document, Powerpoint Slide, Excel Chart
etc. - Yes, there may be better ways of storeing this for multiple records.
What needs to be asked is if it is appropriate for what you need? Or
should you be designing the database in such a way that the information
should be put into tables and then you generate the output in a way that you
need?
I use a stored Excel sheet wich puts in shipping information from a
records and then saves the changes to another Excel file outside of Access.
Why do I do it this way? 1. I know where the template Excel sheet is at all
times. - It can't be moved, deleted or changed by anyone without access to
the Access application. Sure there are other ways to handle those reasons,
but this is just simpler, or an added advantage. Why don't I just design a
Report? The cusotomer who gets the Excel file wants it in Excel.

What we need to know is:
What is the Excel Sheet being used for?
Why do you think you can't use a Report for the generated data?

There are other questions I would ask before determining what is the
best approach to your specific situation, but this will help.

Craig Hornish
(e-mail address removed) - so I can delete it when it becomes a spam magnet

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"