I would like to use the Form section of Access to input information into an
Excel Spreadsheet. I'm new with Access and find it hard to set up a complete
database structure, but I already have the spreadsheet. I find it nice to
use the form layout, but do not want my spreadsheet in Access- to many
limitations and I find it hard work with.

Thanks

On Wed, 7 Nov 2007 10:56:00 -0800, Sasko <(E-Mail Removed)>
wrote:

>I would like to use the Form section of Access to input information into an
>Excel Spreadsheet. I'm new with Access and find it hard to set up a complete
>database structure, but I already have the spreadsheet. I find it nice to
>use the form layout, but do not want my spreadsheet in Access- to many
>limitations and I find it hard work with.
>
>Thanks

Unfortunately, Microsoft lost a lawsuit last year, and were obliged to remove
the ability to update an Excel spreadsheet from an Access application. It's
just barely possible to do what you ask but it requires a good deal of
programming.

Just remember - Excel is a spreadsheet, Access is a relational database. They
are emphatically *not* interchangable. Each tool is appropriate for the kinds
of tasks that it was designed for; but you're right, that Access does not "do"
spreadsheets at all well (just as Excel does not "do" relational data modeling
at all well).

John W. Vinson [MVP]

Oh well, thanks

"John W. Vinson" wrote:

> On Wed, 7 Nov 2007 10:56:00 -0800, Sasko <(E-Mail Removed)>
> wrote:
>
> >I would like to use the Form section of Access to input information into an
> >Excel Spreadsheet. I'm new with Access and find it hard to set up a complete
> >database structure, but I already have the spreadsheet. I find it nice to
> >use the form layout, but do not want my spreadsheet in Access- to many
> >limitations and I find it hard work with.
> >
> >Thanks
>
> Unfortunately, Microsoft lost a lawsuit last year, and were obliged to remove
> the ability to update an Excel spreadsheet from an Access application. It's
> just barely possible to do what you ask but it requires a good deal of
> programming.
>
> Just remember - Excel is a spreadsheet, Access is a relational database. They
> are emphatically *not* interchangable. Each tool is appropriate for the kinds
> of tasks that it was designed for; but you're right, that Access does not "do"
> spreadsheets at all well (just as Excel does not "do" relational data modeling
> at all well).
>
> John W. Vinson [MVP]
>