Changing excel spreadsheet into ms access style database within excel?
I am
in the process of cutting and pasting some columns and rows of data from ms excel to access so it can be presented in a database format.
is there a feature within excel that can do this automatically?
i would
leave the data in excel as most people don't have ms access.
Answer
You could try building an excel form into 1 worksheet, then have it fill in the entered data in the appropriate column of another worksheet. i have never done it, but have seen it done before.
read up on it in the helpfiles, or check out the microsoft knowledge base.
Related Products
Warning: DOMDocument::loadXML() [
domdocument.loadxml]: Extra content at the end of the document in Entity, line: 2 in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/domxml-php4-to-php5.php on line
61
Fatal error: Call to a member function document_element() on a non-object in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/amazon.php on line
50
