Access forms for Excel Spreadsheet

[Guest]

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

 

[John W. Vinson]

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]

 

[Guest]

Oh well, 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]