Hello
I have a large spredsheet consisting of 3,500 rows and approx 50 columns from which I need to make a database.
I need to have a "form template" which I can merge the spreadsheet data into and print each individual record (which is each individual row with 50 fields) separately.
Ideally I need this to look like an access database, but am not sure if this can be done in excel.
I don't know if I've explained myself clearly.
Any help is greatly appreciated. ray:
Thank you.
I have a large spredsheet consisting of 3,500 rows and approx 50 columns from which I need to make a database.
I need to have a "form template" which I can merge the spreadsheet data into and print each individual record (which is each individual row with 50 fields) separately.
Ideally I need this to look like an access database, but am not sure if this can be done in excel.
I don't know if I've explained myself clearly.
Any help is greatly appreciated. ray:
Thank you.