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've 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
