I have an excel spreadsheet in the format much like a financial statement
Dates along the top in rows
account along the left first column
When I link (or import), access dumps all of the accounts into a single column "Field 1" and I find it difficult to develop queries.
I think what I am looking for is how to convert the excel file to a table with all the account names as separate fields and not all dumped into one field named "Field 1". (see pic below)
Grateful for your help.