Creating a new db by Importing Excel Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PJ - 27 Apr 2008 15:58 GMT

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

Reply to this Message

Ken Snell (MVP) - 27 Apr 2008 20:16 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> What would the best way to design a db based off of a excel spreadsheet?
> The
[quoted text clipped - 11 lines]
>
> Thanks in advance

Reply to this Message