help with worksheet with access

[polar the great dog]

I have a large worksheet which I enter a reference number and some details
for that reference, I would like to be able to store this in maybe access
then when I enter the reference is re entered I can edit the values.

any ideas?>

 

[Guest]

I guess I'm confused about what the question is...

You can create tables in Access with spreadsheet data, but you should
normalize the data before loading the tables. Once spreadsheet could be
several normalized tables. It isn't always a good idea to just take a
spreadsheet and create a table out of it. You may run into problems later
when you want to create queries.

Read up on Access and table normalization for your solution.