Creating a new db by Importing Excel Spreadsheet

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
 
K

Ken Snell \(MVP\)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing spreadsheet cells that have multiple values 1
Importing excel spreadsheet into two tables at the same time 1
How to link single excel spreadsheet to multiple access tables 1
Importing Excel Spreadsheet into Access 6
Importing Excel data into Access 6
Linking Access Database data to Excel Spreadsheet? 5
How to link multiple excel spreadsheets to a single access db? 1
Importing excel spreadsheet with changed data 1

Top