Using functions after importing data from Access

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

Guest

I was successful in importing data from a table in Access. However when I
try to use a function such as "Count" it will not work. It just displays a
zero even though the formula looks correct.

Another question I had was when I import data from Access to Excel is there
a way if I add a record in Access it would make the same change in Excel?
 
What happens if you use COUNTA instead of COUNT? If that will give you a
result that is correct then the numbers are text, try this
Format the import number column as general or numbers etc (NOT text)
select the column, do data>text to columns, click finish
or format an empty cell as general or numbers, copy it, select the import
and do edit>paste special and select add
 
Back
Top