Creating a new db by Importing Excel Spreadsheet

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

What would the best way to design a db based off of a excel spreadsheet? The
spreadsheet has two columns :

First Column has all the questions
Second has all the answers with some of them being drop down boxes.

I will getting these spreadsheets from multiple people (30) and on a weekly
basis. I do not know yet if this data will be over written on a weekly basis
or be needed for historical information. Then I will be creating multiple
reports based off this information,

Thanks in advance
 
One would not design a database based on a single EXCEL worksheet, but one
might design a table within a database where the table is based on the
single EXCEL worksheet. Create a table that will hold the same data as in
the EXCEL worksheet, then write forms/reports/queries against that table to
analyze your data.
 
Back
Top