Access and Excel

[Guest]

i want to create something, which allows a user to input
data in a spreadsheet by putting values in certain fields.
then access running something which will then take the
data and put it into a form/design page which i have
created in excel.

any help appreciated

 

[John Vinson]

i want to create something, which allows a user to input
data in a spreadsheet by putting values in certain fields.
then access running something which will then take the
data and put it into a form/design page which i have
created in excel.

any help appreciated

Sounds complicated; why do you want to have the user go from an Excel
spreadsheet to another Excel spreadsheet with Access as an
intermediary? Wouldn't just an Excel Form be simpler? Please explain!

 

[Guest]

because i want access to check spelling and validation
etc. plus i want access to remove certain records if they
have been incorrectly entered and i want them to be placed
in a new table. so i can then check those incorrect
entries and modify them personally.