Data Migration from Excel to Access

[dcsfm2004]

I have got so many big excel sheets, I have always problems in manipulating the data. So we have decided to migrate it to Access. I just started designing DB. I am new to this DB modelling.

I just started storing Data which is not calculated value. If it is calculated value I am ignoring. I would like to calculate the calculated value directly in UI.

My question, Is it a good practice to Ignore all the cal´culted values??

what are the limitations of IF conditions in Access ?

 

[BrianB]

Not sure what you are trying to do. Might be better to give an example of what you are trying to achieve.

If you want to do calculations in Access you have to set up a Query with an additional column to hold the calculated value.

I use Access and Excel quite a lot to analyse text files when my usual procedure is to make an Excel worksheet from the text file, import into an Access table for lookups/number crunching. My Queries are usually a "Make Table" Query so I can import data into Excel for formatting and analysis.

This might seem a roundabout way, but I have found that this overcomes problems with corrupt files, strange formatting problems, and the slowness of =VLOOKUP() in Excel. There is also the possibility of error checking at each stage.

I have found no real problems with IF in Access.

Hope this helps.