Here's my dilemma.
I have a stock market portfolio created in Excel with 1000-odd records with many columns containing duplicate data: Account, Strategy, Product, Exchange, Stock Code, Stock Name, etc etc.
Creating a new portfolio manager in Access, I have two options: Create separate tables for each Excel column of data, normalising the duplicate data into separate tables and linking them to the main portfolio manager table with Combo Boxes to select the data for entering new records (looks great but a nightmare for importing to)... OR, create just one main table in Access allowing me to import directly all the data as it appears in Excel, allowing duplicate data to exist. But un-normalised.
What's everyone's thoughts? I use Excel now because it's simply fast for formatting and manipulating data, But Access looks and operates more professionally. The image below is the main portfolio manager window I've created in Access so far, but no imported data exists yet. Thanks.