How to make excel rows into an Access Record

  • Thread starter Thread starter Paul Mernaugh
  • Start date Start date
P

Paul Mernaugh

I have a spreadsheet that has varying rows for each record and want to
import this into Access. For example, Row 1 is the subject. Rows 2,3,4 are
fields for Row 1. Row 5 is the subject, yet 6 and 7 are fields for Row 5 and
so on. The Subject is in column 1 and subsequent columns are descriptions of
the record. How do I import this into access so that each group, or Record
appear in Access as 1 record, and not a record for each row?

Any help would be appreciated.

Thanks,

Nigel
 
Manually input it?

Ok, how about a sample of the data, or something like the data.

Give us a subject then the contents of the fields and then the
descriptions.

We need to figure out what table construction you need first.

We also need to know what you want to get out of the data. How are you
going to use it. Calculations? Search? What? Why do you not want to stick
with Excel?

Then maybe, maybe not, we can figure a way to get it into a database.
Then again we may be back to my first suggestion.
 
All that would go very easily into Access using just the default
settings and letting Access make the decisions. After importing it you can
let Access split or suggest splitting the table for a more efficient
structure.

I am not sure what you want to do with the data, so I am not sure if you
would even want to use Access as the tool. Why do you want to change from
Excel?
 
Back
Top