importing data from Microsoft Works

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a table and I imported my data from Microsoft Works 2000 by saving
it as dbIV and importing it. I had several calculated fields in the Works
form. When I tried to add data using Acess it would not calculate anything.
How do I get this to work in Acess2003
 
Joyce said:
I created a table and I imported my data from Microsoft Works 2000 by
saving it as dbIV and importing it. I had several calculated fields
in the Works form. When I tried to add data using Acess it would not
calculate anything. How do I get this to work in Acess2003
Click to expand...

You should not be copying or saving calculated data. You should
re-calculate it in a form, query or report as needed.
 
I created a table and I imported my data from Microsoft Works 2000 by saving
it as dbIV and importing it. I had several calculated fields in the Works
form. When I tried to add data using Acess it would not calculate anything.
How do I get this to work in Acess2003
Click to expand...

Access tables do not HAVE calculated fields.

Just import the raw data, and create a Query based on the table; you
can put expressions in the vacant Field cells of the query definition
to do the calculations.

John W. Vinson[MVP]
 
Back
Top