Converting Records from Excel to Access

[Excel_77]

Hi All,

I have a main spreadsheet that has 68 column's on it, some of the columns populate from a separate spreadsheet while others populate internally via built in calculations with a final number manually populated.

I want to covert this main spreadsheet into an Access format, what is the best way to do this?

 

[RedBeard]

This might be of use: https://support.office.com/en-us/ar...35392a68ed53#bmwork_with_excel_data_in_access

 

[Micron]

FWIW, most spreadsheets make poor tables. Spreadsheet data is seldom normalized since the purposes don't really complement each other. You might want to check out db normalization if you don't know what I mean, before you start hitting walls.