I am sure by many developers standards, this is a popular subject/topic. I am looking for resources online that document, help, explain, and even examples of How Excel Spreadsheets and workbooks can be MIGRATED over to Access 2000 (Office 2000).
I am preferably looking for “Online Books” that have chapters that discuss this popular migration, but general web documented diagramming will also work great.
I am required to get a lot of Excel data into a Database file, which can have Forms for inputs of additional info as well as query generated reporting and such. I assume that going as far as using Visual Basic would not be necessary, but I believe Forms, and Reports can be easily created within Access with the wizards.
Any help on this popular, but not well documented data migration would be greatly appreciated. Thanks you very much!
Paul M. Chavez