import excel spreadsheet

[Guest]

I am re-designing an Excel spreadsheet that is used to create service
contracts. I realize that Access is the way to go about this, but I am
having a hard time with the forms. The spreadsheets themselves are set up to
mimic the final printed versions of the pages, so they are not revisable. Is
there a way to import these spreadsheets into Access as FORMS so I can add
fields from the tables I will create, thereby populating the forms and making
them easier to print? I'm no beginner in Access, but am not well-versed in
VBA or VB for that matter. I can create the forms in Access from scratch in
design view, but I know that that will take a LOT of time. If I can import
these spreadsheets as-is as an Access Form, it will save me LOADS of time.

Any assistance on this matter will be greatly appreciated.

SBR

 

[Van T. Dinh]

Sorry, no. Excel and Access are good "friends" but they are not 100%
compatible. The DatasheetView of an Access Table / Query may look like an
Excel spreadsheet but underneath an Access Datasheet and an Excel
spreadsheet are different.

OTOH, you need to think of _database structure_ when you use Access and the
"database" thinking/logic is quite different to the "spreadsheet"
thinking/logic.

You can try to import the data and then use the Form Wizard to create a Form
in Access. However, I think this is the wrong want to set up a new database
due to the above reason.