Changing Excel spreadsheet into MS Access style database within Excel?

Question: I'm 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 rather 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 Questions

Related Items